Hi
I have a question in joining the records in a sequential file and a table.
Can we directly join/lookup a sequential file and a table (using transformer) or should we have an hash file in between..i have seen this in many jobs that a hashed file is used before joining..but is that mandatory?
join in server job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's not mandatory (to use hashed files), but it's much faster, particularly if the database is not on the same machine as the DataStage server.
Last edited by ray.wurlod on Thu Jan 08, 2009 2:59 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: join in server job
its not mandatory at all..but that wil hep u to quick search the data to join...so its suggestable to have hasfiles as lookup and it can be reusable..dnat wrote:Hi
I have a question in joining the records in a sequential file and a table.
Can we directly join/lookup a sequential file and a table (using transformer) or should we have an hash file in between..i have seen this in many jobs that a hashed file is used before joining..but is that mandatory?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: