Left outer Join not resulting Null values of right table

Amin · Post by **Amin** » Tue Jan 27, 2015 11:03 am

After left join its right table columns having varchar datatype value should be NULL but columns have values like empty single quote ''

ray.wurlod · Post by **ray.wurlod** » Tue Jan 27, 2015 4:24 pm

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).

Amin · Post by **Amin** » Wed Jan 28, 2015 10:01 am

Thanks for reply

We explicitly define all collumns of right table to Nullable.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 28, 2015 3:31 pm

What about the output link from the Join stage? Are they all nullable there? (Particularly the ones coming from the "Right" input?)