Incremetal load from 1 fact to another fact
2 posters
Page 1 of 1
Incremetal load from 1 fact to another fact
Hi
i have a situation.
There is a fact A and fact B which acts as a source for another fact C. The Fact A and B contains detail values which are loaded daily and Fact C contains aggregated values which is loaded weekly. Fact A and B contains Source_file_name, source_file_date information in them but fact C has no file informations. My questions are
Is it a good practice to have multiple facts as source for another fact?
If yes, then how the data sould be loaded incrementally in fact C?
Regards
Vibhuti
i have a situation.
There is a fact A and fact B which acts as a source for another fact C. The Fact A and B contains detail values which are loaded daily and Fact C contains aggregated values which is loaded weekly. Fact A and B contains Source_file_name, source_file_date information in them but fact C has no file informations. My questions are
Is it a good practice to have multiple facts as source for another fact?
If yes, then how the data sould be loaded incrementally in fact C?
Regards
Vibhuti
vibhutidevatraj- Posts : 1
Join date : 2009-06-08
Re: Incremetal load from 1 fact to another fact
'Is it a good practice to have multiple facts as source for another fact?'
Of course... that is what an aggregate fact table is.
'If yes, then how the data sould be loaded incrementally in fact C?'
There are a lot of ways of doing it. It all depends on what the base feeds look like and how you are updating the base facts. But the simplest is to pull last week's facts from the two tables, aggregate them and push them into the target table.
Of course... that is what an aggregate fact table is.
'If yes, then how the data sould be loaded incrementally in fact C?'
There are a lot of ways of doing it. It all depends on what the base feeds look like and how you are updating the base facts. But the simplest is to pull last week's facts from the two tables, aggregate them and push them into the target table.
Similar topics
» ETL for Fact load
» Loading Fact table
» ETL Fact Load in SSIS
» Fact load with SCD2- join on current row or between dates
» Best method for incremental fact load (inserts and updates) using SSIS
» Loading Fact table
» ETL Fact Load in SSIS
» Fact load with SCD2- join on current row or between dates
» Best method for incremental fact load (inserts and updates) using SSIS
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum