A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
gunjesh3
Participant
Posts: 3 Joined: Fri Nov 17, 2006 5:10 am
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
gunjesh
Developer
satishmelinamani
Participant
Posts: 7 Joined: Wed Jun 28, 2006 1:36 am
Location: Bangalore
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
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
Premium Member
Posts: 210 Joined: Wed Feb 16, 2005 7:17 am
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
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Abhijeet1980
Participant
Posts: 81 Joined: Tue Aug 15, 2006 8:31 am
Location: Zürich
Contact:
Post
by Abhijeet1980 » Sat Nov 25, 2006 8:55 am
Are Merge ad Join stages the same ?
Kind regards
Abhijit Gaikwad
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.