Data Flows & Transformations

As of 2026-05-29

Data Flow = ETL surface for what Replication Flow can't do (multi-source joins, file ingest, complex derivations, Type 2 SCD). Senior rule: prefer Replication Flow; reach for Data Flow only when transformation is needed. Master 7 operators (Source/Target/Join/Projection/Aggregation/Lookup/Filter + Script). Push filters and projections to source. Header comment on every flow = inheritance protection.