Data Flow Design Ideas.

[former_member290153]

Hi All,

I have a scenario where am having 9 source tables and 1 target table. i need to some better idea to design the data flow with joins and using multipul Query transform or single Qry transform.

Source :DB2

Target :DB2

Below is the Table Relationship dig.

[former_member187605 · Accepted solution]

If these are all simple inner or left outer joins, I'd build a data flow with 9 source tables, a single Query transform and the target table.