Do not use staging tables as a source for validation checks
-
Recommendation: When you create a validation check, do not include columns from staging tables as its source.
-
Rationale: Staging tables are intermediate steps in a data transformation. They are not intended to be used to raise discrepancies.
-
Additional information: If you use staging tables, we recommend that you use them to explicitly define the intermediate tables in a separate staging model, as specified in the Guidance for DMW Implementation and Configuration document.
We don't recommend using staging tables due to the limitations of the feature.
Parent topic: Validation checks