Load all source data into a data lake and then proceed to load it into the data warehouse.

Request that administrators of the source systems generate a data quality verification prior to exporting the data.

Conduct a data quality assessment on the source data post-extraction. This assessment should include checks for value ranges, value distributions, counts of invalid and missing values, among other source data checks.

Import the data directly into the data warehouse and record any records that do not pass integrity or consistency checks.