SCD: Slowly changing dimensions explained with real examples 

Guys please support me in building my new youtube channel "An Indian Abroad " by watching subscribing and sharing with your friends ru-vid.com

thanks for video got my final interview with amazon in 2 hours!!

SCD explained very well and with so much patience. !! Much appreciated... Thanks for sharing the knowledge on it

Very well explained. I had an issue where I had implemented SCD 1. Later SCD 2 replaced it. I would say SCD 4 is a more elegant way. Great job! thanks for this video

This is very informative, very easy to understand. Thank you so much for this!

Great video. Thanks a lot Vivek for explaining very simply and clearly!

Hi Vivek, Thank you for this video. It helps me a lot. I have watched several training in SCD but they made me much more confuse. But this video helped me to understand. Just I want to mention that as far as I know the surrogate key should change in each update in SCD2.

Superb explanation understand very easily thank you so much bro......

great explanation... thanks for the video

nice explanation with examples

Very Good with example & explanation

Thanks a lot for this video. It really helped me understand SCD and its various types.

good explanation . Really helpful for me. Tq

Very well explained with nice example 🙂 thanks

Excellent performance bro really very nice and clear explanation such containt all the best bro

Superlike!! What I like about your videos is that you give real examples.

very nicely explained. Thankyou

Very crisp and to the point.

Beautifully explained!

very nice video, good knowledge sharing

Thanks dada (bhaiya) for your clear and concise approach to scd.

Too good and simple explanation of SCD.. 👍🏻

clear and practical examples. good job

Hi..Thank you so much for this valuable information that helps me a lot

best explanation ever you are the best

Nicely explained.

Nice sir 👌 👍 👏 😀 thanks 😊

amazing explaination.great job bro

Very precisely and beautifully explained. I was able to understand each and every thing you explained. 👏

Simple and easy !! Great work

Hello Vivek ..thanks for sharing. I noticed that for SCD Type 3 example (at 14:50) when the salary value changes, you left out to put prev_salary and current_salary in the table although you did explain in your video that if there are more than one column change for each column there must be both previous and current values to be kept in DW.

well explained; this SCD types always ask during technical interview.

Thank you! Super concise and clear

Well explained

Simple and clear explanation. Thank you Tech Coach.

Awesome explanation.. totally worth it!

Very well explained . Thanks

Best explanation ever

Vivek brother it's awesome

good explanation

Thank you it is very helpful for me

Amazing Video (y). Get going!

Really great video ,easy to understand

Very nicely explained

Excellent 😊

It was knowledge rain for me, thank you brother for the social work!

Nice explanation sir good 👌

thank you for such good video

Very nice video...just remove subtitles for better understanding...due to that we can not see the tables

Informative.

in SCD0 if we are using the column anymore then doesn't it make sense to delete the column rather than keeping it and not updating?

The way of explanation is damn clear... Very useful for beginners. Thanks a ton for this video

Nice once Vivek......Keep it up

Very nice explanation and real life examples ..kudos

Thanks. Nice and concise explanation of the different types of SCD.

Good info

Thanks, Vivek, really its very good video to understand SCD. If you have any video with the practice session plz share a link for the same which helps more clear.

Nice explanation

Dear Sir , is primary or surrogate key in SCD2 will remain same for multiple entry of the same record ? As mentioned in this clip if it will remain same then how will we update the previous record ?

Good Job!

thank you so much very help full

Simply awesome

Very well explained. Thank you!

Too good 👍👍

Excellent Explanations Skills!!!

Very nice man❤️❤️

Thank you very much for this simplest explanation I could find over youtube! Awesome :)

please upload videos regarding SCD based scenarios wth both SQL and informatica (two approaches) your explanation methodology is very good.

Hi Vivek, Your video was very helpful. Just one query. In case of SCD 2, can we have duplicate value for id??As it has 123 in all the cases.

Excellent video. Only question is on scd 6. Why did you set old value equal to current value in last row?

Great explaining sir ,make more update video sir

Much appreciated ....

Hi Vivek..very nice explanation..!! I have one question - for SCD 4 why we need to maintain two different tables for latest snapshot and history, we can just create a view on our SCD2 dim with condition 'to_date='12-dec-99' for the latest snapshot data and normal 'As-is' view for historical data. Please let me know if I'm missing anything. Thanks again..every video of yours is really helpful.

Thank you for the clear explanation!

Thank you so much bhai 💙

Very clear explanation One question - On SCD2 Main table and SCD 4 History table, the amount of data will be same Plus SCD4 will occupy more memory than SCD2 to store one extra table. But, if we need 2 reports it is better to have one extra table so that quering is fast. In such scenarios , SCD2 is better or SCD4?

9:52 ID Column I assume as a Primary key in that case in Data warehouse table new ID gets generated or Same ID get repeated?

Thank you for not having an accent so thick that you can't be understood! There are times that I have pulled videos like this and the speakers accent is so bad that they would be better off speaking their native language!

You deserve much more viewers than now since you narrated the concepts very well,I like your videos, Thanks, dear friend.

In SCD6 current office and history office is given. Then why not current salary and historical salary is mentioned. Is that intentional?

Well explained vivek... Big thumps up

excellent stuffs and nicely explained.

Good one!

awesome vid

thats awesome...very well explained..thank you very much bro.

Hello thank you very much for this. For SCD type II, in your example, what happens if you are pulling data from the source every day and some day the id 123 doesn't come? How will you reflect that change in your data warehouse table? and what if then the id 123 comes again? Is this possible? Thanks

Question: In SCD3 why columns are created for only location, When it comes to change in dimensions for salary & date , why there is no columns for that ? Is SCD3 rule by default consider particular column type ? I do understand that these type does not consider past history, but why then its maintain past history for location ?

what is slowly changing grain is it same as slowly changing dimension?

Explanation was very precise and through the point.I really like the way you explained..!! Could you please explain the concept of granularity in depth and its significance.. Thanks in advance.!

This is some wonderful explanation. And they way you explain is so easy to understand and follow. Thank you so much Bro!

If my source table has no date column, Can we apply SCD 2 on my source table to update?

Beautiful

Two Words: Volume Leveling! Had to crank my speakers up to 100% just to barely hear you

Thank you!

It’s pretty cool thank you

Very informative and concise video. Thanks!

Clear cut explanation

Very well explained. Thanks a lot..

wouldn't the SK which in your example appears to be ID change when you apply SCD 2? You have kept 123 for all the records in DW while applying SCD 2. As SK is also PK I don't see how it would work. Please confirm.!

Can you do a video on Change data capture...