Data Validation for the Transformation fields

Dear All,

We have crises-cross transformation in the JDM.
Eg:- Fields have been transformed from Sales Header to Sales Line and vice versa.
The reporting requirement was of Summary and Transaction reports. The summary reports were drawn from Sales header and some fields required at the Summary level like Line Amount were taken from the Sales line table.

We need to ensure that all transformation field have been populated with the relevant data. Now we have written validation queries to check the table count from source to staging and from staging to DW,but we are not sure how to validate that the data has been populated in the transformation fields in both the tables?


Please sign in to leave a comment.