SCD - Slowly Changing Dimension in Data Warehouse

Title: Slowly Changing Dimensions | All you need to know about SCD
Description -
Slowly changing dimension is a way of accommodating/adjusting changes in dimensions.
In this video, we will learn about slowly changing dimensions. SCD or Slowly Changing Dimensions is a common dimensional scenario, that comes in data warehouses but it is a critical design process for developers. We will dive down to understand different approaches - type 1, type 2 and type 3 and corresponding techniques to deal with each of them.
Subscribe - / @aroundbi
About AroundBI : We are trying to create an educational platform with an aim to provide tutorials in a very simple and understandable way.
Get more on AroundBI
-----------------------
DATA WAREHOUSE:
Title - Types of Fact Tables in Data Warehouse | Transaction, Periodic and Accumulating
KZbin URL - • Types of Fact Tables i...
Title - What is Grain in Data warehouse
KZbin URL - • What is Grain in Data ...
Title - Fact Table Structure in Data Warehouse
KZbin URL - • Fact Table Structure i...
Title - Why Surrogate Keys are used in Data Warehouse
KZbin URL - • Why Surrogate Keys are...
Title - Dimension Table Structure in Data warehouse
KZbin URL - • Dimension Table Struct...
Title - What is Dimension and Fact in Data Warehouse
KZbin URL - • What is Dimension and ...
-----------------------

[@nitsiet]

You deserve absolute appreciation for explaining this concept clearly.

[@adityabohra6836]

Your videos are clear and crisp. I always watch them before any interview this gives me more confidence. Please posting such great videos on DWH concepts. Thank you for great content.

[@sivapula8613]

Real time example !! Really the appreciate the Uniqueness !!!

[@sumit-visatotravel8780]

This is so much clearly stated with perfect examples. Keep it up!

[@akshayborhade8673]

Beyond Excellence. No words to express how useful it was to me. Thank you so much !!

[@ketanbhikadiya4679]

Finally found someone who is so clear. Entire playlist is nice. Please upload more videos on dimensional modelling and kimball methodology. Thanks for your work.

[@ketanbhikadiya4679]

@aroundBI can you pls share the ppt for this playlist?

[@krish808]

Appreciate your presentation, I'm struggling to find clear explanation for a while, finally I found 👍

[@geeseeoh]

In our datawarehouse we use type 2 with processdate. This is the date when the data was entered into the table. This allows us to see historical snapshots of data. Which is useful when you are analyzing trends like balances. So you can see how balances change overtime.

[@mrrownel]

Clear explanation. Excellent video! Thank you!

[@douglastchouandop6581]

I appreciate your all yours presentations, very simple and very clear. I read manies books but...thank you!

[@shofwatulafifah]

clearly explained, very helpful for me. thank you!

[@marcelo157films]

Excellent tutorial! Thank you for share!

[@KasmitharamKr]

This is super helpful, and really awesome for last-minute interview preparations! Thanks!

[@vinaysagarkomarabanda747]

Impressed with your Explanation..

[@priyanshipundir55]

The way you cleared the concept. Hats off

[@bassfischer4273]

Terrifically informative series! Thank you.

[@budmonk2819]

Excellent explanation. The concept was always slippery, but you nailed it to the brain.

[@tamborelconejo]

thanks mate, this was really awesome, big thank you. Best SCD explanation in youtube

[@pratikkhobragade2870]

Excellent! Thank you!

[@naveenkumarmurugan1962]

Excellent Buddy!

[@PM-eb9cn]

Awesome videos. Great explanations. Thanks a lot

[@nickvega6815]

Clear explanation. Very helpful. Thanks

[@rakhigawde13]

Best video on topic ..good job. Thanks a lot

[@saurabhgarud6690]

Very helpful content in very easy words !! Thank you !!

[@vivekbhamare7575]

Good explain with answers of questions like why ? when ? and how ? Using SCD .

[@gauravjain8987]

Very nicely Explained. Congratulations!

[@sravankumarreddylingareddy3854]

Excellent tutorial bro, we will expect another topics like this.

[@Ziadvb971]

Very helpful, Thank!

[@akshaykapoor8180]

thank you for such clear and nice explanation.

[@rutujagawade3908]

Very clearly explained, thank you

[@suvendudalai]

thanks for explaining the concept clearly i hv saved the link and revise my concepts regularly👍👍

[@nirmalamanthngauda1517]

Thank you so much, how well you have explained, Expecting more such vedios from you

[@AMARJEETKUMAR-ce9sc]

Good Understanding of concept..Thankyou..

[@ruhirana25]

Really nic tutorial.. thanks for sharing info

[@publicpoint1032]

Simply superb

[@Ashok-oe3lo]

Really very helpful, thank you very much...

[@sanketchaudhari3458]

Very difficult topic you have explained in simple words.. Thank you sir

[@Desleiden]

Very helpful Sir, thank you!

[@mohammadazharuddin4352]

Greatly appreciate!

[@gurunathreddy822]

very neatly explained thanks bro

[@pritammishra9850]

such a lucid explanation..Thanks a lot :)

[@wossentarkgne8087]

wonderful explanation thank you

[@kumarankit5702]

Excellent Explanation 👍

[@tummalasaiharish8149]

perfectly described

[@ps4909]

Excellent tutorial

[@maddmaster]

More people need to like these videos and subscribe to this channel. We should reward the creator for such an amazing work.

[@cajaykiran]

Thank you!

[@srivatsansathyamurthy876]

Excellent

[@advanceskills5469]

one of the best videos

[@getptv8356]

good tutorial thank you

[@shivendrakhare1583]

wow ! such a good explanation. Loved it.

[@sreenivasprasad6195]

Well explained bro.. this is helping a lot Thank u :)

[@tusharsonwane8468]

Superb explanation 👍

[@Sharmasurajlive]

Fantastic 👍🏻

[@mullaipugazhendi3236]

Excellent 😊

[@swathisai4845]

Great explanation sir👏

[@padmachowdarykothapalli891]

Awesome

[@Shreya-ff9dx6fv1s]

Awesome very good explanation 👍👍👍👍👍👍👍👍👍

[@norpriest521]

Please don't delete this playlist Data warehouse aroundbi Very important playlist from your channel in my career

[@shwethav.r7100]

excellent!!

[@bhanupriya691]

Very useful

[@mukeshkalambe2795]

amazing

[@moradsaid6703]

Great Great Great ...

[@hrsh3329]

Good one

[@rpallothu]

you are truely awesome

[@gomes8335]

Too good

[@michaeld9682]

Good job

[@archanavijayan3535]

Nice explanation 👌

[@ademajames7250]

You the best

[@DimitriosTsouchlarakis]

good job man

[@awakened514]

Very helpful diagram at 11:43

[@praveenkumarsah5211]

How the delete is handled in SCD Type 2? If record is deleted in source then which will be displayed as active record?

[@nadeenlillahshamaslillah2908]

Good

[@vikrammagoo3776]

Very nice explanation and good presentation....thumbs up from my side. What is your name dude?

[@SS-sp2sx]

In Type 2 dimensions, End Date is never a null value. It will be always 12/31/9999.

[@sanjubell]

good

[@noorchishti2108]

need more videos on schema types pleasee.

[@youjohnny16]

what is the process of updating the surrogate key of related tables?

[@chiranjeeviyeduvaka8319]

How to apply partioning on scd type 2

[@johnaj9042]

Thanks for the video. Easy to understand. But aren't there 6 types of SCD?

[@ferdousadnan5814]

Type 1 and Type 2 you will see mostly used in real world, rarely type 3. These 3 are the main ones used

[@blackisblack22]

I prefer type 1 and 3, the option 3 is the most complicated of them all.

[@rakeshgopidi4066]

Excellent explanation with examples , one of the best playlist on DWH concepts in You tube ,can you please also make some videos Good Reference Vids for any interview this will brush up all the foundations for any experience levels well done doing great job **short note EXPIRY_DATE - instead of null a standard practice is to use high end date - 31/12/9999 Rapidly Changing Dimensions Role Playing Dimensions Galaxy /Factless Schema Super Keys Candidate Keys

[@taknevydder]

C R I S P 👏

[@sanjeevansalvi3683]

can we do scd2 without surrogate key? please reply

[@s13gaming68]

Yes

[@sanjeevansalvi3683]

@@s13gaming68 how

[@sanjeevansalvi3683]

as i have searched for it but dont get any

[@s13gaming68]

@@sanjeevansalvi3683 you can still have primary key of application joined with fact in case of scd2 but make sure put filter on either effective date or current indicator colomn

[@sanjeevansalvi3683]

@@s13gaming68 thank you