Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
justicevb
Participant
Posts: 10 Joined: Thu Jul 03, 2008 6:07 am
Post
by justicevb » Fri Jul 04, 2008 2:31 am
Hi All,
This is venu new to the Data stage.could you please explain about the Merge stage..
please let me know the is there any constraints on input metadata..
is it must to specify the teporary directory path in Merge stage..
Thanks,
Venu.
xxx
sachin1
Participant
Posts: 325 Joined: Wed May 30, 2007 7:42 am
Location: india
Post
by sachin1 » Fri Jul 04, 2008 2:43 am
please can you go through Merge Stage Guide pdf, all your doubts will be clear.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Fri Jul 04, 2008 4:28 am
The Merge stage performs a join between two text files. I do not know whether entering the temporary directory is mandatory, but attempting to compile without it filled in will answer that question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Fri Jul 04, 2008 7:57 am
Not mandatory as it will default to 'the current working directory' - i.e. your Project. Generally a Bad Idea, btw.
-craig
"You can never have too many knives" -- Logan Nine Fingers
PhilHibbs
Premium Member
Posts: 1044 Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:
Post
by PhilHibbs » Thu Jul 10, 2008 5:05 am
chulett wrote: Generally a Bad Idea, btw.
You could say that about the Merge Stage in general, IMHO.
Phil Hibbs | Capgemini
Technical Consultant
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Jul 10, 2008 7:45 am
I guess in principal that I agree, seeing as how I never use it, prefering other mechanisms to 'join' or merge files.
-craig
"You can never have too many knives" -- Logan Nine Fingers
PhilHibbs
Premium Member
Posts: 1044 Joined: Wed Sep 29, 2004 3:30 am
Location: Nottingham, UK
Contact:
Post
by PhilHibbs » Thu Jul 10, 2008 8:22 am
chulett wrote: I guess in principal that I agree, seeing as how I never use it, prefering other mechanisms to 'join' or merge files.
There's only one place I'd use the Merge Stage: if I need to do a many-to-many join.
Phil Hibbs | Capgemini
Technical Consultant