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
Partial records are loaded while joining
Moderators: chulett, rschirm, roy
Partial records are loaded while joining
prabakaran.v
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: