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]

Hi Arun,

if the source tables all have the same columns, you can merge them using the MERGE Transformation and than connect the MERGE Transformation to a Query (where you can manipulate the data)

Best regards

Goran