DSXchange

Hi,

I Have the issue with a 5sets of data,three having the common column and two doesn't have common key column.I want to join this sets and i want to load in target.

Pls help me for this query......

Regards,
Vinodn

Can you provide more detail about the data sets. How are they related? In business terms, how do you wish to join them.

hi,

You could create a dummy column in all of your 5 datasets output link by using column genrator stage or Transformer stage and then merge data using this Dummy column as key column.

Thanks & regards
Sudhindra P S

Hi Sudhindra,

Ok i will try with this solution and i will give u reply.


Regards,
Vinodn