Source Table

[Former Member]

Hello everyone,

I have 10 source tables but the operation i am going to do with that is common. I dont want to have 10 different transforms to perform the same action.

Is there any way i can pass the table name over run time ? so that all my work will be done in one go.

Any leads ?

Thanks,

AJ.

[Former Member]

Arun,

As already suggested, either do a union all in the database or use the Merge transform in Data Services so that you are using a single query transform.

If you have to populate each of these ten tables in 10 separate target tables, you can use a

the table name as an identifier (Include an extra column with your table name?) in your where clause in a query transform after the merge transform.You may still need 10 query transforms but it will save you the hassle of writing complex transforms which you will be doing in your query transform.

10 Sources > Merge > Single Query transform with complex mappings > 10 query xfms with table name in where clause ( If you have separate targets)

Cheers,

Chaitanya