Datastage scenario

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Devendrudu
Participant
Posts: 31
Joined: Tue May 24, 2011 12:16 am

Datastage scenario

Post by Devendrudu »

Hi Friends,

i have two files
f1 have cust_id,Tran_id,sales_amount

f2 have cust_id,cust_name

i want o/p like cust_name, sales_amount


how can do this?
Devendra,Bangalore,India
peddakkagari
Participant
Posts: 26
Joined: Thu Aug 12, 2010 12:07 am

Re: Datastage_scenario

Post by peddakkagari »

Hi,

join File1 and File2 using joiner stage with the key cust_id and return the two columns cust_name, sales_amount .

Please let us know if it is not working

Thanks,
Sreekanth
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Next time let's post in the correct forum, shall we? The FAQ Discussion forum where we came from is for... well, oddly enough... discussing topics that might become FAQs. This one is for Parallel job questions and I'm going to assume that's what this was. Maybe someday you'll let us know your version and O/S.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Bicchu
Participant
Posts: 26
Joined: Sun Oct 03, 2010 10:49 pm
Location: India

Post by Bicchu »

If your file 2 size is not large enough, you can simply do a look-up on the basis of cust_id from file 1 inorder to get the cust_name from file 2 and get your desired result.
Thanks,
Pratik.
Post Reply