Auto Created NULL record ID 0 is missing in referenced tables

[Pierre_G]

My assumption:

1. When running a Data Warehouse tasks, loading a foreign key  column that has a NULL in the source is replaced with 0 and it is tied to the auto-created NULL record (ID=0) in the referenced table.

2. A NULL record with ID 0 is auto-created in the referenced table

My Problem:

When a null value is loaded in a foreign key column, it is replaced with a 0 but the corresponding referenced table does not get the auto-created NULL record (ID=0)

note1: My problem is for all foreign keys.
Note2: The foreign keys are correctly defined in the Model

[Adam_Herman]

Hi @Pierre_G 

I see that you have raised an incident for this behavior to the support team.

Please check the case, as we have asked for additional information to be provided so we can start with our investigation. 

Thank you in advance for your time.

Regards,
Adam

[Nanda_Ravindra · Accepted solution]

@Pierre_G I worked with you on this issue on a support case and you you resolved the issue by dropping and recreating the DWH. The RCA for this issue  was related to using truncate statement in your pre- etl step which is not a suggested method in DWH field. 

Thanks,

Nanda