join in server job

dnat · Post by **dnat** » Thu Jan 08, 2009 2:52 am

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?

ray.wurlod · Post by **ray.wurlod** » Thu Jan 08, 2009 2:55 am

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.

dwh.com · Post by **dwh.com** » Thu Jan 08, 2009 2:56 am

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?

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..

ray.wurlod · Post by **ray.wurlod** » Thu Jan 08, 2009 2:58 am

To dwh.com; please be much more careful with your written English - spelling, grammar and punctuation.

dnat · Post by **dnat** » Thu Jan 08, 2009 4:12 am

thanks Ray and dwh..that cleared my doubt..

DSXchange

join in server job

join in server job

Re: join in server job