Large number of late arriving facts

Jeff Smith at 15h47
08
Feb
2011
Large number of late arriving facts

I am loading a Star Schema from a data base that acts as the staging area. We are converting our source systems to a new transaction system. We are converting data to the new transaction systems in large chunks with conversion dates spread over 3 years. I am only loading data from the staging area only after it has been converted to the new transaction system. When converted, transaction system will contain 3 years of history. As a result, after

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Preserving prior history for late arriving dimensions
Can't find much about this topic anywhere else so hopefully someone can help me. Our warehouse has late arriving dimensions for an Employee. Their department changes, for example, can be backdated in the systems and so we have to account for this and
Business keys in Fact. Is this accepted?
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2
Language translation for large number of codes
The significant dimension tables in our data model each contain 25 or so codes. Example currency code, category code etc. Each of these dimension tables have different sets of codes i.e they do not share identical sets of codes. Each code requires
How to handle Large dimensions 35M records
Hi all. I have a dimension with 35+ million records as compared to 225 Million in the fact table. I am not sure about the kind of penalty we will have to pay for such a big dimension. Here is summary regarding this dimension. This dimension is derive
Updating a Fact Table
I currently working on an Accounting Datamart which the dims and facts are loaded daily. I have recently had a request to update the data after its been loaded. The best way for me to explain this is to give an example. The data is loaded daily, so
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"Large number of late arriving facts"

This topic has been viewed 1208 times.

Last message :
08/02/2011 at 15h47 by "Jeff Smith"