How to join without a key column

vinodn · Post by **vinodn** » Mon Mar 24, 2008 10:06 am

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

mikegohl · Post by **mikegohl** » Mon Mar 24, 2008 10:12 am

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

Sudhindra_ps · Post by **Sudhindra_ps** » Mon Mar 24, 2008 12:16 pm

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

vinodn · Post by **vinodn** » Mon Mar 24, 2008 12:20 pm

Hi Sudhindra,

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

Regards,
Vinodn