Question on Join

sg33 · Post by **sg33** » Wed Dec 02, 2015 12:15 pm

Hi -

Say there are 5 key columns used to do the join. One of those columns has null value from the source as well as the reference table. The other four columns have matching values.

Will a lookup be found in this case? (no null handling is done) or will the job abort or throw a warning etc.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 02, 2015 2:18 pm

What would happen if you were doing this in a database?

Would you expect DataStage to behave the same way?