I have two inputs to the join stage.
1. from a dataset which is hash partitioned on col A and sorted on col B.
2. from a transformer.
In the join stage I used partitioning type as "same" for the link coming from dataset and for the link from transformer I selected the hash partition on col A and sorted on col B.
The key column is col B. With these setting I am getting a mismatch in join. Could someone tell me if there is any mistake in my settings.
Thanks
mismatch in join stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Take a look at the score. DataStage is probably inserting tsort operators that sort on the hash partitioning key. Add Sort stage set to "don't sort (previously sorted)" on the link from the Data Set.
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.
didn't know that!value in colA is the last character of colB
...then i would also expect 'Same' to work......
...are you running this job on the same number of nodes as the job that created the dataset?
..can you do as Ray suggested and take a look at the score? perhaps you could post it here...
Regards,
Nick.
Nick.