Slowly Changing Dimension (SCD) : Type 2 in SQL Server | Data Engineer #sql #sql #dataengineers

What is a Slowly Changing Dimension Type 2?

For More Queries WhatsApp or Call on : [phone]

Here in this video, you will be learning about :
The most frequently utilized dimension in a data warehouse is Type 2 Slowly Changing Dimensions. Data analysis uses data warehouses. In order to analyze data, you must take into account its historical components. Let's examine how SCD Type 2 can be implemented in this video.

#SlowlyChangingDimension #scdtype2 #dataengineers #azure #sql #dbms

Other SCD Types :
Type 0 - Ignore any changes and audit the changes.
Type 1 - Overwrite the changes
Type 2 - History will be added as a new row.
Type 3 - History will be added as a new column.
Type 4 - A new dimension will be added
Type 6 - Combination of Type 2 and Type 3

[abhijitz]

Neat and clean explanation!!
Give him a Oscar!

[ashishdukare]

Thank You so much for this video. There is significantly less video on Youtube that explains SCD2. This was very helpful. I work as a Data Engineer at LTIMindtree company.

[ameyaphadke]

Here along with primary column all other columns which are required to be compared has to be also given in the joining condition

Else even if no change in other values the code will insert new record unnecessarily

[kailashsathia]

That was a beautiful explanation. Thank you!

[amarkhaliq]

in the real world staging data is usually rows that don't change as well as ones that change so the tutorial ignores this. But other than that a good tutorial to get a background on this subject.

[ashishdukare]

It will be helpful to practice if you shared the used queries in the video.

[anujsangawar]

Supposed in source record is deleted can we track deleted record too. Means earlier abc record was in target but now in source record is deleted can we track this delete record?

[saumyadipta]

What happens if the same data for a particular emp no is in staging. Is there a way to not load it at all? Beacuse, in this case it will have same.data for same emp no - one with status 1 and one with 0 in the final scd2 table

[gamegunner]

EMPID is not a primary key here so the primary key violation error is being omitted, any workaround for that ???
Because in realtime scenario empid in general is a primary key, how to create a surrogate key incase the empid is a primary key???
Please respond, thanks in advance.

[basavapn]

Why didn't we include whole query in merge statement instead creating sepearte query to update using merge and then separate insert statement, Can you include both in one merge statement and send query

[MohanrajJayaraman]

Can you share the Script for SCD 2 and similar types using sqlserver.