Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Incremetal load from 1 fact to another fact

Go down

Incremetal load from 1 fact to another fact Empty Incremetal load from 1 fact to another fact

Post  vibhutidevatraj Tue Aug 04, 2009 5:13 am

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

vibhutidevatraj

Posts : 1
Join date : 2009-06-08

Back to top Go down

Incremetal load from 1 fact to another fact Empty Re: Incremetal load from 1 fact to another fact

Post  ngalemmo Tue Aug 04, 2009 11:18 am

'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.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum