SCD type 2 Testing Strategy | ETL Testing Strategy |Slowly Changing Dimensions Testing|SCD 2

This video demonstrates what is SCD 2 and the scenarios we should test while implementation of SCD 2 during Unit, QA and UAT testing. Some of the scenarios discussed in the video includes Column Datatypes and Length Primary Key Indexes Constraints Audit Columns Grants New Records - Insert Change in existing Source Record Existing Records Deletion Max Value limit for Surrogate Key Long Running Session Duplicates from Source Dynamic Lookup Batch Id Failure Success Email Reject on Full Refresh MD5 Column Rapid Changing Dimension SCD 0 Foreign Key Columns used in Fact Table – Indexed or not View Exposed for Downstream or not Source Target Recon Delete Cascade and Late arriving dimensions #TechCoach #SCD2