Data Review: perform an overall review of the source data to catch 10-20% of data issues and address them prior to moving to subsequent stages
Data Cleansing: perform a deeper review with an eye toward mapping appropriate data elements and expect to catch 20-30% of data issues.
Data Massaging: convert source data based on destination values using intermediate. Source inputs from Business Subject Matter and expect to catch 20-30% of data issues
Data Validation: load data to GW staging tables and perform integrity checks to catch remaining data issues