DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
Devendrudu
Participant



Joined: 24 May 2011
Posts: 31

Points: 249

Post Posted: Wed Jun 01, 2011 1:43 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
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



Joined: 12 Aug 2010
Posts: 26

Points: 143

Post Posted: Wed Jun 01, 2011 3:33 am Reply with quote    Back to top    

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
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42520
Location: Denver, CO
Points: 218805

Post Posted: Wed Jun 01, 2011 6:09 am Reply with quote    Back to top    

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

I know I don't say this enough, but I like when you talk to me. It's much better than when nobody talks to me. Or when people that I don't like will not stop talking to me.
Rate this response:  
Not yet rated
Bicchu
Participant



Joined: 03 Oct 2010
Posts: 26
Location: India
Points: 184

Post Posted: Wed Jun 08, 2011 4:11 am Reply with quote    Back to top    

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.
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours