ฝัง
- เผยแพร่เมื่อ 2 ต.ค. 2024
- 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
TH-cam URL - • Types of Fact Tables i...
Title - What is Grain in Data warehouse
TH-cam URL - • What is Grain in Data ...
Title - Fact Table Structure in Data Warehouse
TH-cam URL - • Fact Table Structure i...
Title - Why Surrogate Keys are used in Data Warehouse
TH-cam URL - • Why Surrogate Keys are...
Title - Dimension Table Structure in Data warehouse
TH-cam URL - • Dimension Table Struct...
Title - What is Dimension and Fact in Data Warehouse
TH-cam URL - • What is Dimension and ...
-----------------------
You deserve absolute appreciation for explaining this concept clearly.
Appreciate your presentation, I'm struggling to find clear explanation for a while, finally I found 👍
More people need to like these videos and subscribe to this channel. We should reward the creator for such an amazing work.
Beyond Excellence. No words to express how useful it was to me. Thank you so much !!
Awesome very good explanation 👍👍👍👍👍👍👍👍👍
one of the best videos
I appreciate your all yours presentations, very simple and very clear. I read manies books but...thank you!
clearly explained, very helpful for me. thank you!
Very helpful content in very easy words !! Thank you !!
Real time example !! Really the appreciate the Uniqueness !!!
Very useful
Really very helpful, thank you very much...
In Type 2 dimensions, End Date is never a null value. It will be always 12/31/9999.
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.
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.
@aroundBI can you pls share the ppt for this playlist?
Thank you so much, how well you have explained, Expecting more such vedios from you
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.
This is so much clearly stated with perfect examples. Keep it up!
what is the process of updating the surrogate key of related tables?
Good Understanding of concept..Thankyou..
thank you for such clear and nice explanation.
Awesome videos. Great explanations. Thanks a lot
Excellent Buddy!
Very clearly explained, thank you
I prefer type 1 and 3, the option 3 is the most complicated of them all.
very neatly explained thanks bro
Clear explanation. Excellent video! Thank you!
need more videos on schema types pleasee.
Very helpful diagram at 11:43
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
Excellent! Thank you!
Superb explanation 👍
Very difficult topic you have explained in simple words.. Thank you sir
Excellent tutorial! Thank you for share!
thanks for explaining the concept clearly i hv saved the link and revise my concepts regularly👍👍
you are truely awesome
Nice explanation 👌
Fantastic 👍🏻
Please don't delete this playlist
Data warehouse aroundbi
Very important playlist from your channel in my career
Excellent tutorial
This is super helpful, and really awesome for last-minute interview preparations! Thanks!
Very nice explanation and good presentation....thumbs up from my side. What is your name dude?
thanks mate, this was really awesome, big thank you. Best SCD explanation in youtube
Good explain with answers of questions like why ? when ? and how ? Using SCD .
Excellent 😊
Thank you!
good job man
How the delete is handled in SCD Type 2? If record is deleted in source then which will be displayed as active record?
Well explained bro.. this is helping a lot Thank u :)
C R I S P 👏
wow ! such a good explanation. Loved it.
Good one
Clear explanation. Very helpful. Thanks
amazing
Excellent explanation. The concept was always slippery, but you nailed it to the brain.
good
Good
Impressed with your Explanation..
Very nicely Explained. Congratulations!
Very helpful Sir, thank you!
such a lucid explanation..Thanks a lot :)
The way you cleared the concept. Hats off
wonderful explanation thank you
Terrifically informative series! Thank you.
Thanks for the video. Easy to understand. But aren't there 6 types of SCD?
Type 1 and Type 2 you will see mostly used in real world, rarely type 3. These 3 are the main ones used
Really nic tutorial.. thanks for sharing info
Best video on topic ..good job.
Thanks a lot
Great explanation sir👏
Excellent tutorial bro, we will expect another topics like this.
How to apply partioning on scd type 2
Excellent Explanation 👍
Very helpful, Thank!
Simply superb
excellent!!
Greatly appreciate!
Excellent
Good job
good tutorial thank you
Great Great Great ...
perfectly described
You the best
Awesome
can we do scd2 without surrogate key? please reply
Yes
@@s13gaming68 how
as i have searched for it but dont get any
@@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
@@s13gaming68 thank you
Too good