Slowly Changing Dimension | scd 0, scd 1,scd 2,scd 3,scd 4,scd 6 | Practical Example | DataWarehouse

[@AmitSoni-gb2nn]

Really well explained in short time with examples, Nice job bro.Thanks

[@thehouseofconcepts]

Thanks for your kind words !! Keep supporting the channel !!

[@ashishvardhan9064]

U have explained it very well Sir.

[@thehouseofconcepts]

Thank you so much! Please keep supporting the channel…

[@sanjaymange6904]

Thank you sir , very nicely explained

[@thehouseofconcepts]

Thank you! Please keep supporting the channel…

[@gyanpattnaik520]

Beautifully explained... Keep up this good work bro.. 👍

[@thehouseofconcepts]

thank you so much...please keep supporting the channel...

[@pratibhasalunke1512]

Thank you so much.. great explanation..😊

[@thehouseofconcepts]

Thank you so much! Glad it was helpful!

[@ankitkalwar5570]

Very nicely explained, thank you

[@thehouseofconcepts]

Glad you’re finding it helpful!

[@GaneshJadhav-oh1hp]

really well explained sir

[@thehouseofconcepts]

Thank you so much! Please keep supporting the channel…

[@tusharsonwane8468]

Superb explanation 👍 thank you

[@thehouseofconcepts]

Thank you for appreciating!

[@SandipanSarkar-c8v]

Finished watching

[@thehouseofconcepts]

Thank you 🙏🏼

[@sunilnagulkar5871]

super explained 🙂

[@thehouseofconcepts]

Glad you liked it! Please keep supporting the channel!

[@thehouseofconcepts]

Data Warehouse Playlist Link : ua-cam.com/play/PLFbjn94wCCeWqODvODLOFHq16PqwHpRQC.html

[@prasadpatil5397]

Very nice 👍

[@thehouseofconcepts]

Thanks .. Keep Supporting the channel !!

[@astropanda1623]

Very good explanation

[@thehouseofconcepts]

Thanks for your kind words !! Keep supporting the channel !!

[@abhijitmali6837]

Nice 👍 keep it up ❤️

[@thehouseofconcepts]

Thank you!

[@jaivalsartandmore....1199]

Very well explained , I have requirement where I need to implement SCD type 6 , could you please assist me on some implementation part .

[@thehouseofconcepts]

Thanks for your kind words !! For your question Could you please let me know any specific reason for not choosing Type 2 SCD and going for Type 6 SCD...

[@phanikumar7665]

What if the Dimension table has more columns say Street1,Street2, City,State, Zip, So in this case we need to replicate all these columns again, is it good practice for type 3

[@thehouseofconcepts]

Practically, in real world projects we will use SCD Type 2 or Type 4 to cater the scenarios you have mentioned.
If we are using SCD Type 2 we can use Timestamp and Flag to refer latest record. Also some organizations follow SCD Type 4 concept where separate history tables are designed for tracking the changes and main dimension table to showcase the latest record only... Hope this helps!!

[@phanikumar7665]

@@thehouseofconcepts thanks

[@Rockstar01]

Nicely explained but how to do or how to apply ??

[@thehouseofconcepts]

Will come up with a video for practical implementation as well in near future...

[@AnalyticswithProfessor]

😇

[@godbhaigod]

Type 5 kaha gaya

[@ritikpatil4077]

Tu banale,
naya invention

[@pratibhasalunke1512]

​@@ritikpatil4077 😂

[@alevenkateshwarulu-rh9gz]

Type 5 ....u did not tell

[@thehouseofconcepts]

Hi Ale, Are you looking for any specific scenario related to type 5 or just want to understand type 5 in a conceptual manner , As the frequency of usage of type 5 is less...