Page 1 of 1
Datastage scenario
Posted: Wed Jun 01, 2011 1:43 am
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?
Re: Datastage_scenario
Posted: Wed Jun 01, 2011 3:33 am
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
Posted: Wed Jun 01, 2011 6:09 am
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.
Posted: Wed Jun 08, 2011 4:11 am
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.