how to comapre 2 flat file

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

Post Reply
jagadish9
Participant
Posts: 10
Joined: Sat Jun 10, 2006 10:16 am

how to comapre 2 flat file

Post by jagadish9 »

Hi
iam getting the souce data in flat files.
i have to join those flat files on particular colums and derive the new filed for one of the flat file..
its a huge data can i use lookup for this
merge i tried but its saying that this stage can't take any input links
how can i do that in server jobs
Last edited by jagadish9 on Sat Jul 14, 2007 4:45 pm, edited 1 time in total.
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

Do a Normal lookup, It will work fine.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The Merge stage, since you actually mean 'join' rather than 'compare'.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply