Skip to Content

Data Flow Design Ideas.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jun 20, 2017 at 02:04 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded