Slowly Changing Facts

SQLServerCentral Article

Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table

  • Article

This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.

4.07 (15)

You rated this post out of 5. Change rating

2013-08-19

10,090 reads

Blogs

Azure SQL offerings

By

There are three Azure SQL products with so many different deployment options, service tiers,...

T-SQL Tuesday #183 Roundup

By

I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....

A Little Brainstorming with an AI

By

I was asked to do some a little thinking and brainstorming recently. Rather than...

Read the latest Blogs

Forums

Having issues installing SSIS extension for VS 2022 Community

By daniel.manke

I have installed the SSIS extension for VS 2022 community. When I go into...

Traditional vs Self-Publishing Which Professional Book Publishing

By harryzack

Hey writers, I’m in the process of publishing my book and debating between traditional...

Is Ransomware Fading?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Ransomware Fading?

Visit the forum

Question of the Day

A Simple Choice

I have this data in a table?

CatIDCatName
3Monitors
What is returned when I run this code?
SELECT CHOOSE(catid, 'Laptops', 'PCs') FROM dbo.Categories AS c
 

See possible answers