Problem in joining 2 datasets
Moderators: chulett, rschirm, roy
Problem in joining 2 datasets
I am trying to join (Inner) 2 datasets.The problem I am facing is the join output gives 0 rows and I find that one of the input dataset is sending only a few rows out of many rows it contains (shown by Performance statistics).What could be the reason for this.
Re: Problem in joining 2 datasets
The reason for getting zero output is no matching records and datastage only dispolays the number of records accessed to achieve the join, not necessarily all the records present in a link. So check why there are no matching records. If you want to see if there is any anomaly in the way datastage is behaving do a full outer join and see if all records from the input links to join are being read and everything is being output to the target.
:D
:D
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If the join keys are VarChar, make sure they are trimmed of leading and trailing space characters. Make sure that your data are identically hash partitioned and sorted on the join keys.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.