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 pick and choose what to do with it.

I generally want things to be so loose that it won't fail unless the load file is unusable.