DSXchange

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?

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

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.

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.