Hi,
DS 8.7 on Windows
I am doing a left Outer join (Join Stage) on an Integer key field and both inputs are Hash Partitioned and Sorted (inbuilt Join stage sort used) on the same key (No Nulls on either links)
But when the same job runs multiple times I am getting varying number of Duplicate records from this join? (Dups are expected from this join)
Any ideas/suggestions on how to solve this?
Thanks,
NV
Join Stage Varying Results
Moderators: chulett, rschirm, roy
When running the same job with the same input-data using hash-partitioning and sorting on identical columns of both input-links to a join you can't get different results in subsequent runs.
So when you did not change the jobs design it is very likely that your input-data has changed between the first and a later run of the job.
So when you did not change the jobs design it is very likely that your input-data has changed between the first and a later run of the job.
"It is not the lucky ones are grateful.
There are the grateful those are happy." Francis Bacon
There are the grateful those are happy." Francis Bacon
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India