DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
praburaj



Group memberships:
Premium Members

Joined: 30 Jun 2005
Posts: 133
Location: philippines
Points: 1398

Post Posted: Mon Apr 17, 2017 8:46 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I have two dataset in my prod job and doing left outer join based on the column(GL_PROD,GL_ACCT). The key columns datatype is Decimal. After completing the run, out of two records only one record was populated into target datset even though key column values are matched. Due to that,unable to complete the run.

Kindly assist on this how to sort out this issue.

Source dataset-->
---------------------------
GL_PROD GL_ACCT ID_DEPT

100.,54876.,343
100.,54876.,589

Reference dataset
----------------------
GL_PROD GL_ACCT

100.,54876.

Target Dataset:
-----------------
100,54876,343

_________________
prabakaran.v
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 53980
Location: Sydney, Australia
Points: 292863

Post Posted: Tue Apr 18, 2017 12:43 am Reply with quote    Back to top    

What stage type are you using? For example this (not picking up duplicates) is default behaviour for a Lookup stage.

Are there any warnings in the job log?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Mike



Group memberships:
Premium Members

Joined: 03 Mar 2002
Posts: 1010
Location: Omaha, NE
Points: 6513

Post Posted: Tue Apr 18, 2017 7:10 am Reply with quote    Back to top    

If you are using a join stage, check your link order. Your source dataset should provide the data for the left link and your reference dataset should provide the data for the right link Your results are indicative of having them backwards.

Mike
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