Тёмный
No video :(

SCD - Slowly Changing Dimension in Data Warehouse 

aroundBI
Подписаться 13 тыс.
Просмотров 85 тыс.
50% 1

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

Опубликовано:

 

29 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 91   
@nitsiet
@nitsiet 3 года назад
You deserve absolute appreciation for explaining this concept clearly.
@adityabohra6836
@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
@sivapula8613 2 года назад
Real time example !! Really the appreciate the Uniqueness !!!
@ketanbhikadiya4679
@ketanbhikadiya4679 4 года назад
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
@ketanbhikadiya4679 4 года назад
@aroundBI can you pls share the ppt for this playlist?
@geeseeoh
@geeseeoh 7 месяцев назад
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.
@nirmalamanthngauda1517
@nirmalamanthngauda1517 Год назад
Thank you so much, how well you have explained, Expecting more such vedios from you
@AMARJEETKUMAR-ce9sc
@AMARJEETKUMAR-ce9sc Год назад
Good Understanding of concept..Thankyou..
@priyanshipundir55
@priyanshipundir55 Год назад
The way you cleared the concept. Hats off
@sanketchaudhari3458
@sanketchaudhari3458 Год назад
Very difficult topic you have explained in simple words.. Thank you sir
@norpriest521
@norpriest521 3 года назад
Please don't delete this playlist Data warehouse aroundbi Very important playlist from your channel in my career
@rutujagawade3908
@rutujagawade3908 7 месяцев назад
Very clearly explained, thank you
@akshaykapoor8180
@akshaykapoor8180 7 месяцев назад
thank you for such clear and nice explanation.
@Shreya-ff9dx6fv1s
@Shreya-ff9dx6fv1s 2 года назад
Awesome very good explanation 👍👍👍👍👍👍👍👍👍
@maddmaster
@maddmaster 2 года назад
More people need to like these videos and subscribe to this channel. We should reward the creator for such an amazing work.
@krish808
@krish808 4 года назад
Appreciate your presentation, I'm struggling to find clear explanation for a while, finally I found 👍
@suvendudalai
@suvendudalai 2 года назад
thanks for explaining the concept clearly i hv saved the link and revise my concepts regularly👍👍
@gurunathreddy822
@gurunathreddy822 2 года назад
very neatly explained thanks bro
@KasmitharamKr
@KasmitharamKr Год назад
This is super helpful, and really awesome for last-minute interview preparations! Thanks!
@tusharsonwane8468
@tusharsonwane8468 Год назад
Superb explanation 👍
@akshayborhade8673
@akshayborhade8673 5 лет назад
Beyond Excellence. No words to express how useful it was to me. Thank you so much !!
@ps4909
@ps4909 2 года назад
Excellent tutorial
@sumit-visatotravel8780
@sumit-visatotravel8780 6 лет назад
This is so much clearly stated with perfect examples. Keep it up!
@budmonk2819
@budmonk2819 3 года назад
Excellent explanation. The concept was always slippery, but you nailed it to the brain.
@advanceskills5469
@advanceskills5469 2 года назад
one of the best videos
@mullaipugazhendi3236
@mullaipugazhendi3236 9 месяцев назад
Excellent 😊
@archanavijayan3535
@archanavijayan3535 2 года назад
Nice explanation 👌
@douglastchouandop6581
@douglastchouandop6581 4 года назад
I appreciate your all yours presentations, very simple and very clear. I read manies books but...thank you!
@tamborelconejo
@tamborelconejo 3 года назад
thanks mate, this was really awesome, big thank you. Best SCD explanation in youtube
@vivekbhamare7575
@vivekbhamare7575 4 года назад
Good explain with answers of questions like why ? when ? and how ? Using SCD .
@awakened514
@awakened514 2 года назад
Very helpful diagram at 11:43
@hrsh3329
@hrsh3329 2 года назад
Good one
@PM-eb9cn
@PM-eb9cn 3 года назад
Awesome videos. Great explanations. Thanks a lot
@bhanupriya691
@bhanupriya691 3 года назад
Very useful
@nickvega6815
@nickvega6815 4 года назад
Clear explanation. Very helpful. Thanks
@rpallothu
@rpallothu Год назад
you are truely awesome
@cajaykiran
@cajaykiran Год назад
Thank you!
@Sharmasurajlive
@Sharmasurajlive 2 года назад
Fantastic 👍🏻
@vinaysagarkomarabanda747
@vinaysagarkomarabanda747 5 лет назад
Impressed with your Explanation..
@SS-sp2sx
@SS-sp2sx 3 года назад
In Type 2 dimensions, End Date is never a null value. It will be always 12/31/9999.
@DimitriosTsouchlarakis
@DimitriosTsouchlarakis Год назад
good job man
@mrrownel
@mrrownel 6 лет назад
Clear explanation. Excellent video! Thank you!
@mukeshkalambe2795
@mukeshkalambe2795 2 года назад
amazing
@noorchishti2108
@noorchishti2108 Год назад
need more videos on schema types pleasee.
@shofwatulafifah
@shofwatulafifah 4 года назад
clearly explained, very helpful for me. thank you!
@saurabhgarud6690
@saurabhgarud6690 4 года назад
Very helpful content in very easy words !! Thank you !!
@Desleiden
@Desleiden 3 года назад
Very helpful Sir, thank you!
@shivendrakhare1583
@shivendrakhare1583 2 года назад
wow ! such a good explanation. Loved it.
@swathisai4845
@swathisai4845 3 года назад
Great explanation sir👏
@nadeenlillahshamaslillah2908
@nadeenlillahshamaslillah2908 4 года назад
Good
@Ashok-oe3lo
@Ashok-oe3lo 3 года назад
Really very helpful, thank you very much...
@wossentarkgne8087
@wossentarkgne8087 4 года назад
wonderful explanation thank you
@publicpoint1032
@publicpoint1032 4 года назад
Simply superb
@bassfischer4273
@bassfischer4273 3 года назад
Terrifically informative series! Thank you.
@pratikkhobragade2870
@pratikkhobragade2870 5 лет назад
Excellent! Thank you!
@sreenivasprasad6195
@sreenivasprasad6195 3 года назад
Well explained bro.. this is helping a lot Thank u :)
@pritammishra9850
@pritammishra9850 4 года назад
such a lucid explanation..Thanks a lot :)
@sanjubell
@sanjubell 3 года назад
good
@naveenkumarmurugan1962
@naveenkumarmurugan1962 6 лет назад
Excellent Buddy!
@marcelo157films
@marcelo157films 6 лет назад
Excellent tutorial! Thank you for share!
@gauravjain8987
@gauravjain8987 5 лет назад
Very nicely Explained. Congratulations!
@sravankumarreddylingareddy3854
Excellent tutorial bro, we will expect another topics like this.
@kumarankit5702
@kumarankit5702 5 лет назад
Excellent Explanation 👍
@rakhigawde13
@rakhigawde13 5 лет назад
Best video on topic ..good job. Thanks a lot
@ruhirana25
@ruhirana25 6 лет назад
Really nic tutorial.. thanks for sharing info
@youjohnny16
@youjohnny16 2 года назад
what is the process of updating the surrogate key of related tables?
@shwethav.r7100
@shwethav.r7100 3 года назад
excellent!!
@vikrammagoo3776
@vikrammagoo3776 5 лет назад
Very nice explanation and good presentation....thumbs up from my side. What is your name dude?
@Ziadvb971
@Ziadvb971 4 года назад
Very helpful, Thank!
@srivatsansathyamurthy876
@srivatsansathyamurthy876 5 лет назад
Excellent
@blackisblack22
@blackisblack22 Год назад
I prefer type 1 and 3, the option 3 is the most complicated of them all.
@mohammadazharuddin4352
@mohammadazharuddin4352 4 года назад
Greatly appreciate!
@michaeld9682
@michaeld9682 5 лет назад
Good job
@johnaj9042
@johnaj9042 3 года назад
Thanks for the video. Easy to understand. But aren't there 6 types of SCD?
@ferdousadnan5814
@ferdousadnan5814 Год назад
Type 1 and Type 2 you will see mostly used in real world, rarely type 3. These 3 are the main ones used
@tummalasaiharish8149
@tummalasaiharish8149 6 лет назад
perfectly described
@getptv8356
@getptv8356 6 лет назад
good tutorial thank you
@praveenkumarsah5211
@praveenkumarsah5211 6 лет назад
How the delete is handled in SCD Type 2? If record is deleted in source then which will be displayed as active record?
@moradsaid6703
@moradsaid6703 5 лет назад
Great Great Great ...
@padmachowdarykothapalli891
@padmachowdarykothapalli891 6 лет назад
Awesome
@ademajames7250
@ademajames7250 6 лет назад
You the best
@rakeshgopidi4066
@rakeshgopidi4066 2 года назад
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
@chiranjeeviyeduvaka8319
@chiranjeeviyeduvaka8319 6 лет назад
How to apply partioning on scd type 2
@taknevydder
@taknevydder 2 года назад
C R I S P 👏
@sanjeevansalvi3683
@sanjeevansalvi3683 5 лет назад
can we do scd2 without surrogate key? please reply
@s13gaming68
@s13gaming68 5 лет назад
Yes
@sanjeevansalvi3683
@sanjeevansalvi3683 5 лет назад
@@s13gaming68 how
@sanjeevansalvi3683
@sanjeevansalvi3683 5 лет назад
as i have searched for it but dont get any
@s13gaming68
@s13gaming68 5 лет назад
@@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
@sanjeevansalvi3683 5 лет назад
@@s13gaming68 thank you
@gomes8335
@gomes8335 5 лет назад
Too good
Далее
Understand Slowly Changing Dimensions
23:21
Просмотров 20 тыс.
🎙ПОЮ ВЖИВУЮ!
3:17:56
Просмотров 1,5 млн
Женщина на опознании
00:11
Просмотров 13 тыс.
журавли в пятницу
00:14
Просмотров 92 тыс.
7 Different Types of Dimensions in a Data Warehouse!
8:56
Working with Slowly Changing Dimensions in Power BI
13:31
Types of Facts | Data Warehouse Concepts
5:43
Просмотров 79 тыс.