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

[@t_geek9211]

Wow, thank you man! This is a great educative content! There are very few materials on data engineering on youtube. Thank you for filling up this hole!

[@nanajama4537]

Great video! One of the best I’ve come across

[@TechCoach]

Thanks a lot buddy :)

[@ashwinisuryawanshi5947]

Thanks a lot, this video helped me very much

[@TechCoach]

I am glad Ashwini, I could help :)

[@surajpatil3579]

Thanks for covering in such detailed manner 👍 if possible share or make video on common testcase template for etl testing 🙋 keep making content like this @techcoach 👏👏

[@TechCoach]

Sure Suraj, I will work on them

[@omkarbelpatre5]

Thank you so much

[@TechCoach]

Thanks Omkar :)

[@sachingond3229]

Thanks a lot Bhai!!!

[@TechCoach]

I am glad I could help :)

[@aniketkadam4167]

How to write test cases.plz share video.

[@sachingond3229]

Can we merge target_backup with new data in source and then minus it from original target to check scd1 i.e. upsert logic testing??

[@TechCoach]

I am not sure If I understand your questions correctly Sachin

[@shivussshetagar2816]

Rapid changing dimensions are not included in target and it's not the part for reporting .. Please correct me if I'm wrong

[@TechCoach]

Rapid changing dimensions are normalized in order to reduce the data size , you can use the normalized tables for your reporting without any issues. Infact you find the table with static records used for your reports often.

[@KiranTrends]

Bhai sql queries dedo...scd2 ke all

[@prasadkokane7561]

Hi Sir, my source don’t have unique key it contains duplicates, I just have new business_date every day how I can implement scd type 2?

[@TechCoach]

Can you please paste the table structure prasad?

[@prasadkokane7561]

@@TechCoach I found solution. I am creating temp table with max business_date and from that temp table, loading into DIM table using Merge statement.