DSXchange

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.

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

Would you expect DataStage to behave the same way?