nullability for join stage
Posted: Thu May 22, 2008 10:16 am
Hello Gurus,
following is the fact for join stage:
when we use Join stage, Be particularly careful to observe the nullability properties for input links to any form of Outer Join. Even if the source data is not nullable, the non-key columns must be defined as nullable in the Join stage input in order to identify unmatched records.
why does this rule exist for join stage ?
thanks very much!
following is the fact for join stage:
when we use Join stage, Be particularly careful to observe the nullability properties for input links to any form of Outer Join. Even if the source data is not nullable, the non-key columns must be defined as nullable in the Join stage input in order to identify unmatched records.
why does this rule exist for join stage ?
thanks very much!