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?
Datastage scenario
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Tue May 24, 2011 12:16 am
Datastage scenario
Devendra,Bangalore,India
-
- Participant
- Posts: 26
- Joined: Thu Aug 12, 2010 12:07 am
Re: Datastage_scenario
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
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers