Null Substitution in Joins
Posted: Thu Jan 10, 2008 11:03 am
Hi
I am encountering a strange thing while performing join in Datastage.
When i perform a left/right join on on two datasets in DS then it substitutes Null for non matching records but when i perform a join between a dataset and teradata enterprise stage then it substitutes :
1) Blanks for character values
2) Zeroes for integral values
for non-matching Teradata Enterprise data but NULLs for dataset non matching values.
So is it that NULLS are not substituted in DS after joins for non matching Teradata records?
I am encountering a strange thing while performing join in Datastage.
When i perform a left/right join on on two datasets in DS then it substitutes Null for non matching records but when i perform a join between a dataset and teradata enterprise stage then it substitutes :
1) Blanks for character values
2) Zeroes for integral values
for non-matching Teradata Enterprise data but NULLs for dataset non matching values.
So is it that NULLS are not substituted in DS after joins for non matching Teradata records?