Slowly Changing Dimensions In Data warehousing with iPhone 11 Example | SCD 1/2/3

In real world dimensions do not remain constant. with the change in Dimension value we need to keep track of all the data in history. SCD type 1/2/3 are different way on maintaining your data warehouse tables . In this video we will understand how the tables looks like in SCD 1/2/3 and when to use what.

Video content:
00:00 : Background
01:45 : SCD 1
04:30 : SCD 2
09:33 : SCD 3

Most Asked Join Based Interview Question:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #dataengineer #scd #datawarehousing

[divyaaggarwal]

Very well explained, Ankit.
Will look forward to more DataWarehousing sessions.

[fadwa]

Excellent!! looking forward to more DataWarehousing and Modelling sessions

[akash]

Thanks Ankit . for starting DWH series .i request you make a video on how to cover kimbell effective way . like important topics it would be great .

[nidhisingh]

Your all videos are fantastic. Still waiting for more Data warehouse videos

[SanjaySingh-bmit]

Please make SQL video as well . Waiting for more Data warehouse videos :)
Thanks a ton for explaining in such a simple manner

[radhikasood]

Thank you for making this amazing video, It solved many of my concepts. Please make video on how to handle SCDs using SQL. Would love to see your approach on this.

[mayankpandey]

Plz share video with SQL query explaining about SCD 1, scd2 &scd 3

[nareshch]

Hi Ankit please do more videos on data modeling and SCD.

Thank you!!

[Pasdpawn]

sir please create a video on implementation. Theory is easy to remember but i was asked how to implement it and i went blank. there are hardly any videos available online which deals with its Great work btw

[abb_raj]

Requesting for more data warehouse lecture videos and also data management videos.Thanks bhai.

[krishnakumar-gchb]

Requesting more such data warehouse and data modeling videos @ankit

[IamRavitheja]

Very good explanation bro, keep adding more important concepts videos for data engineers (DWH and Data Modelling ). Thanks alot for your efforts. Really helpful 💯👍

[DataScienceSchools]

I love your content, because your words are very simple but very effective, and please keep this simplicity, never try to use heavy jargon words so that any one can learn from you.

[ganeshkumar]

As usual your explanation rocks .will look forward to more data ware concepts .

[soumyasamriddhicoder]

Please Make full course videos on data modeling and data warehousing ASAP

[gurumoorthysivakolunthu]

Hi Sir...
Please make scd type 1, 2 implementation video...
Thank you...

[swagatikajena]

Really thanks a Very very useful to us 👍🙏

[pruthvirajkoramoni]

Excellent explanation.. Please make more videos on data modelling and datawarehousing concepts

[amanmishra]

Hi Sir, can you help us with the implementation of type 1 and type 2 SCD records in SQL?
Thanks in advance

[Brown_Munda_oo]

please make a video on this topic
how to use, where to use in SQL