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
deesh
Participant



Joined: 08 Oct 2007
Posts: 188

Points: 1897

Post Posted: Tue Jan 30, 2018 9:07 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,
I am using lookup, from main Stream getting 3582, and from reference getting 112 records , but lookup output 16201 records.

Using continue( left join), if we mention continue output should match 3582.

Please help me out, if some one faced this kind of issue
qt_ky



Group memberships:
Premium Members

Joined: 03 Aug 2011
Posts: 2813
Location: USA
Points: 21315

Post Posted: Tue Jan 30, 2018 3:48 pm Reply with quote    Back to top    

Perhaps you have the Lookup stage set to allow multiple records to be returned from the reference link.

_________________
Choose a job you love, and you will never have to work a day in your life. - Confucius
Rate this response:  
Not yet rated
deesh
Participant



Joined: 08 Oct 2007
Posts: 188

Points: 1897

Post Posted: Tue Jan 30, 2018 7:15 pm Reply with quote    Back to top    

From reference getting distinct records.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54372
Location: Sydney, Australia
Points: 294928

Post Posted: Wed Jan 31, 2018 2:53 am Reply with quote    Back to top    

How do you know that? How else could you get more records out than came in on the stream input?

Are you using Auto partitioning?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
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