JOIN TWO SEQUENTIAL FILE

gunjesh3 · Post by **gunjesh3** » Wed Nov 22, 2006 1:48 am

Hi All,
I would like to know how to join two sequentail file in Datastage without using third party tool.
pls don't confused with merge file. I want to know abt how to join.

regards
gunjesh

satishmelinamani · Post by **satishmelinamani** » Wed Nov 22, 2006 4:26 am

You can make use of Transformer Stage and Join both the files based on Key fields (in Constraints)

Eg: Table1.EMPID=Table2.EMPID

ArndW · Post by **ArndW** » Wed Nov 22, 2006 5:02 am

Satish,

that solution will not work with flat files in DataStage Server. Try it and see.

ArndW · Post by **ArndW** » Wed Nov 22, 2006 5:04 am

you could load one of the flat files to a hashed file using the keys you want to join on, and then use a transform stage with a lookup to perform your join.

aakashahuja · Post by **aakashahuja** » Wed Nov 22, 2006 5:18 am

Or you could use the UNIX 'join' command in the Before Job Subroutine of the job to join the two files.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 22, 2006 7:34 am

The Merge stage in server jobs is specifically designed to join two sequential files.

Abhijeet1980 · Post by **Abhijeet1980** » Sat Nov 25, 2006 8:55 am

Are Merge ad Join stages the same ?

chulett · Post by **chulett** » Sat Nov 25, 2006 9:04 am

No... and don't confuse the Merge stage in the Server product with the stage of the same name in the PX product. The Merge being discussed here is the Server Merge stage.

ray.wurlod · Post by **ray.wurlod** » Sat Nov 25, 2006 12:57 pm

That's because Server was specified in the original post. There is no Join stage in server jobs.

DSXchange

JOIN TWO SEQUENTIAL FILE

JOIN TWO SEQUENTIAL FILE

Re: JOIN TWO SEQUENTIAL FILE