Can resources corrupt a join?
Posted: Wed Aug 01, 2007 9:19 am
Is it possible for server resources to impact a join without throwing an error? I have a job that left outer's on two datasets that produces incorrect results every now and then. The join matches on key's that do not exist and thus I'm getting incorrect values from the right columns.
I've verified that the partitioning is correct. Subsequent job runs produce the desired result. Has anyone experienced a similar issue?
I've verified that the partitioning is correct. Subsequent job runs produce the desired result. Has anyone experienced a similar issue?