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
RUclips URL - • Types of Fact Tables i...
Title - What is Grain in Data warehouse
RUclips URL - • What is Grain in Data ...
Title - Fact Table Structure in Data Warehouse
RUclips URL - • Fact Table Structure i...
Title - Why Surrogate Keys are used in Data Warehouse
RUclips URL - • Why Surrogate Keys are...
Title - Dimension Table Structure in Data warehouse
RUclips URL - • Dimension Table Struct...
Title - What is Dimension and Fact in Data Warehouse
RUclips URL - • What is Dimension and ...
-----------------------

[@nitsiet]

You deserve absolute appreciation for explaining this concept clearly.

[@sumit-visatotravel8780]

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

[@sivapula8613]

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

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

[@marcelo157films]

Excellent tutorial! Thank you for share!

[@akshayborhade8673]

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

[@mrrownel]

Clear explanation. Excellent video! Thank you!

[@krish808]

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

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

[@bassfischer4273]

Terrifically informative series! Thank you.

[@vinaysagarkomarabanda747]

Impressed with your Explanation..

[@shofwatulafifah]

clearly explained, very helpful for me. thank you!

[@douglastchouandop6581]

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

[@pratikkhobragade2870]

Excellent! Thank you!

[@naveenkumarmurugan1962]

Excellent Buddy!

[@rakhigawde13]

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

[@sravankumarreddylingareddy3854]

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

[@KasmitharamKr]

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

[@PM-eb9cn]

Awesome videos. Great explanations. Thanks a lot

[@nickvega6815]

Clear explanation. Very helpful. Thanks

[@ruhirana25]

Really nic tutorial.. thanks for sharing info

[@tamborelconejo]

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

[@priyanshipundir55]

The way you cleared the concept. Hats off

[@gauravjain8987]

Very nicely Explained. Congratulations!

[@budmonk2819]

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

[@Ziadvb971]

Very helpful, Thank!

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

[@saurabhgarud6690]

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

[@AMARJEETKUMAR-ce9sc]

Good Understanding of concept..Thankyou..

[@Ashok-oe3lo]

Really very helpful, thank you very much...

[@publicpoint1032]

Simply superb

[@rutujagawade3908]

Very clearly explained, thank you

[@Desleiden]

Very helpful Sir, thank you!

[@getptv8356]

good tutorial thank you

[@mohammadazharuddin4352]

Greatly appreciate!

[@akshaykapoor8180]

thank you for such clear and nice explanation.

[@pritammishra9850]

such a lucid explanation..Thanks a lot :)

[@wossentarkgne8087]

wonderful explanation thank you

[@kumarankit5702]

Excellent Explanation 👍

[@tummalasaiharish8149]

perfectly described

[@gurunathreddy822]

very neatly explained thanks bro

[@vivekbhamare7575]

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

[@ps4909]

Excellent tutorial

[@srivatsansathyamurthy876]

Excellent

[@shivendrakhare1583]

wow ! such a good explanation. Loved it.

[@Sharmasurajlive]

Fantastic 👍🏻

[@nirmalamanthngauda1517]

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

[@mullaipugazhendi3236]

Excellent 😊

[@Shreya-ff9dx6fv1s]

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

[@cajaykiran]

Thank you!

[@tusharsonwane8468]

Superb explanation 👍

[@swathisai4845]

Great explanation sir👏

[@suvendudalai]

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

[@advanceskills5469]

one of the best videos

[@maddmaster]

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

[@padmachowdarykothapalli891]

Awesome

[@sreenivasprasad6195]

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

[@shwethav.r7100]

excellent!!

[@sanketchaudhari3458]

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

[@hrsh3329]

Good one

[@archanavijayan3535]

Nice explanation 👌

[@bhanupriya691]

Very useful

[@michaeld9682]

Good job

[@mukeshkalambe2795]

amazing

[@moradsaid6703]

Great Great Great ...

[@DimitriosTsouchlarakis]

good job man

[@rpallothu]

you are truely awesome

[@gomes8335]

Too good

[@ademajames7250]

You the best

[@norpriest521]

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

[@praveenkumarsah5211]

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

[@chiranjeeviyeduvaka8319]

How to apply partioning on scd type 2

[@nadeenlillahshamaslillah2908]

Good

[@vikrammagoo3776]

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

[@awakened514]

Very helpful diagram at 11:43

[@sanjubell]

good

[@noorchishti2108]

need more videos on schema types pleasee.

[@SS-sp2sx]

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

[@youjohnny16]

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

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

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

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