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

[@nanajama4537]

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

[@TechCoach]

Thanks a lot buddy :)

[@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!

[@omkarbelpatre5]

Thank you so much

[@TechCoach]

Thanks Omkar :)

[@ashwinisuryawanshi5947]

Thanks a lot, this video helped me very much

[@TechCoach]

I am glad Ashwini, I could help :)

[@sachingond3229]

Thanks a lot Bhai!!!

[@TechCoach]

I am glad 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

[@aniketkadam4167]

How to write test cases.plz share video.

[@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.

[@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