Not null variable produces Null values

[David_Billa]

I'm loading the data from SAS to SQL table via SCD type 2 loader. There are two fields which are defined as Null in SQL but after loading I could see the Null values. These  two fields are not Primary key in SQL and it is under 'Detect changes' in SCD type 2 from SAS.

May I know what might be the potential cause for this issue?

[Patrick]

"There are two fields which are defined as Null in SQL but after loading I could see the Null values."

What does that mean? There had been blanks instead of NULL? Or the SCD2 loader loaded a change record even though nothing changed?

SAS not having a concept of NULL will make things really hard. The md5 digest value gets created on the SAS side so I would assume that a change from blank to NULL (or the other way round) wouldn't create a change record as for SAS it's both times a blank.

How a missing/blank then gets inserted into the DB (as blank or as NULL) will depend on your option settings (NULLCHAR, NULLCHARVAL).