Versioning Fact
4 posters
Page 1 of 1
Versioning Fact
Hi,
Just 2 basic questions would be helpfull if you can clarify.
1. Can a Fact table be versioned? I have a requirement for displaying data as it was at any point of past time in the database. For this it is required to maintain versions in Fact table. Is it possible? If so, what is this fact table called.
2. SCD is referred to only Dimension table or Fact table also?
Just 2 basic questions would be helpfull if you can clarify.
1. Can a Fact table be versioned? I have a requirement for displaying data as it was at any point of past time in the database. For this it is required to maintain versions in Fact table. Is it possible? If so, what is this fact table called.
2. SCD is referred to only Dimension table or Fact table also?
DWHquestions- Posts : 2
Join date : 2011-09-13
Re: Versioning Fact
1. Yes, Snapshot fact
2. Dimension only
2. Dimension only
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Versioning Fact
We use a publication date as another attribute in the table.
So while a record may be a "late-lander" based on it's start date, the publication date will allow us to recreate the exact same numbers as it is the date when the data was "published" to the data warehouse.
So while a record may be a "late-lander" based on it's start date, the publication date will allow us to recreate the exact same numbers as it is the date when the data was "published" to the data warehouse.
Re: Versioning Fact
Although the SCD2 technique properly only apply to dimensions, many people have implemented SCD2-like facts with BeginEffectiveDate and EndEffectiveDate fields.
Ralph Kimball presented this pattern in the "Dimensional Modeling in Depth" class as "Instanteous Balances". It allows quering the state of afairs at any moment in time in the past. However, the catch is once you do this in your fact table you must ALWAYS CONSTRAIN YOUR QUERIES AGAINST THAT FACT TABLE BY DATE... FOR THE REST OF YOUR LIFE. Dr. Kimball compared this to getting hooked drugs--you need to take it every day for the rest of your life!
Ralph Kimball presented this pattern in the "Dimensional Modeling in Depth" class as "Instanteous Balances". It allows quering the state of afairs at any moment in time in the past. However, the catch is once you do this in your fact table you must ALWAYS CONSTRAIN YOUR QUERIES AGAINST THAT FACT TABLE BY DATE... FOR THE REST OF YOUR LIFE. Dr. Kimball compared this to getting hooked drugs--you need to take it every day for the rest of your life!
VHF- Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US
Similar topics
» Versioning Fact rows?
» Versioning in the fact table
» Cost plans for projects - One fact table or several fact tables?
» Fact, factless fact, and current view dimensions
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
» Versioning in the fact table
» Cost plans for projects - One fact table or several fact tables?
» Fact, factless fact, and current view dimensions
» Single fact table vs multiple fact tables - what is the right way in a dimensional model?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|