Skip to Content
0

Data Flow Design Ideas.

Jun 17, 2017 at 04:58 AM

68

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dirk Venken
Jun 20, 2017 at 02:04 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded