Merging a DataBase table with Hashfile
Posted: Tue Dec 07, 2004 9:53 pm
hi all
i have a stream of data coming in from a hash file.i have a table which holds additional information for the stream of records coming in.
i want to join both the streams of data based on a key.
Solution 1:i could use a transformer and made my table as a refernce link and Lkup and fill the information.
I guess this will not work because i have duplicates for the joining column in my table
Solution 2: i got to use a Merge stage to join these streams.
Problem with this approach Merge takes only works on files in server.
Is putting the Data from my table in to hash file and working with merge only way or is there any way out of this?
Thanks and Regards
Pavan
i have a stream of data coming in from a hash file.i have a table which holds additional information for the stream of records coming in.
i want to join both the streams of data based on a key.
Solution 1:i could use a transformer and made my table as a refernce link and Lkup and fill the information.
I guess this will not work because i have duplicates for the joining column in my table
Solution 2: i got to use a Merge stage to join these streams.
Problem with this approach Merge takes only works on files in server.
Is putting the Data from my table in to hash file and working with merge only way or is there any way out of this?
Thanks and Regards
Pavan