What he said, except for the Data Vault part… 😉

Seriously, in a data warehouse we always 'land' loads like this in a staging table with minimal constraints. You can then...