Join Stage Varying Results
Posted: Tue Apr 09, 2013 8:03 am
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
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