Page 1 of 1
Left outer Join not resulting Null values of right table
Posted: Tue Jan 27, 2015 11:03 am
by Amin
After left join its right table columns having varchar datatype value should be NULL but columns have values like empty single quote ''
Posted: Tue Jan 27, 2015 4:24 pm
by ray.wurlod
Looks like the metadata are specifying a default value and that null handling is not enabled on the output link (that is, the output column is not defined to be nullable).
Posted: Wed Jan 28, 2015 10:01 am
by Amin
Thanks for reply
We explicitly define all collumns of right table to Nullable.
Posted: Wed Jan 28, 2015 3:31 pm
by ray.wurlod
What about the output link from the Join stage? Are they all nullable there? (Particularly the ones coming from the "Right" input?)