Partial records are loaded while joining

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
praburaj
Premium Member
Premium Member
Posts: 133
Joined: Thu Jun 30, 2005 1:26 am
Location: philippines

Partial records are loaded while joining

Post by praburaj »

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
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Mike
Premium Member
Premium Member
Posts: 1021
Joined: Sun Mar 03, 2002 6:01 pm
Location: Tampa, FL

Post by Mike »

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
Post Reply