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
Merging a DataBase table with Hashfile
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 133
- Joined: Tue Nov 23, 2004 11:24 pm
- Location: India
-
- Participant
- Posts: 85
- Joined: Fri Jun 04, 2004 2:30 am
- Location: Melbourne, Australia
- Contact:
-
- Premium Member
- Posts: 133
- Joined: Tue Nov 23, 2004 11:24 pm
- Location: India
Instead of table lookup use the hash file so that you won't have duplicates in the lookup.
Merge is used with sequential and you can't use this with hash file. Make sure that you eliminate the duplicates with correct logic.
Cheers
Merge is used with sequential and you can't use this with hash file. Make sure that you eliminate the duplicates with correct logic.
Cheers
Regards
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar
Siva
Listening to the Learned
"The most precious wealth is the wealth acquired by the ear Indeed, of all wealth that wealth is the crown." - Thirukural By Thiruvalluvar