Multiple rows from different sources into single row
Posted: Thu Oct 24, 2013 3:51 am
Hi all,
I am just a data stage beginner. I've been searching on the forums on whether it's possible to merge multiple rows from different sources into one row. So far the pivot stage seems to be the closet thing to what I want but I'm still not sure it will meet my requirements. Let me explain.
I have a stream of data in my parallel job that starts off at an oracle stage. It returns three rows. From the oracle stage I have three transformers. Each to handle the three different types of data.
The output columns of the first transformer is the following columns...
Member no, member valid
The output of the second transformer is ...
Staff no, staff valid
The output of the third transformer is ....
Valid card
Normally you would end up with three output rows but My question is how can I end up with one row which combines the content of the three rows...
Member no, member valid, Staff no, staff valid, Valid card
All these rows do have a transaction key in common which I can use if required. What stage would best be suited for what I want?
Thanks for your help.
I am just a data stage beginner. I've been searching on the forums on whether it's possible to merge multiple rows from different sources into one row. So far the pivot stage seems to be the closet thing to what I want but I'm still not sure it will meet my requirements. Let me explain.
I have a stream of data in my parallel job that starts off at an oracle stage. It returns three rows. From the oracle stage I have three transformers. Each to handle the three different types of data.
The output columns of the first transformer is the following columns...
Member no, member valid
The output of the second transformer is ...
Staff no, staff valid
The output of the third transformer is ....
Valid card
Normally you would end up with three output rows but My question is how can I end up with one row which combines the content of the three rows...
Member no, member valid, Staff no, staff valid, Valid card
All these rows do have a transaction key in common which I can use if required. What stage would best be suited for what I want?
Thanks for your help.