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

Loading data from one fact to another summary fact

+3
rademola
hang
Jamie
7 posters

Go down

Loading data from one fact to another summary fact Empty Loading data from one fact to another summary fact

Post  Jamie Thu Jan 06, 2011 2:42 am

Hello Folks,

I am looking to take the information from one Account fact table and then load it into another account summary fact table and then end of every month. Is this right architecture.. This is absolutely required for periodic snapshot

So on the whole can I load data from one fact table and another fact table.

Thanks in advance for the reply.


Jamie

Posts : 1
Join date : 2011-01-06

Back to top Go down

Loading data from one fact to another summary fact Empty Re: Loading data from one fact to another summary fact

Post  hang Thu Jan 06, 2011 4:11 am

Of course you can, and you should. The periodic snapshot in your case are the aggregates based on transaction facts. Loading aggregates from base level facts can guarantee the reconcilable rolling up.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

Back to top Go down

Loading data from one fact to another summary fact Empty Re: Loading data from one fact to another summary fact

Post  rademola Thu Jan 06, 2011 6:07 am

Yes it is the logical thing to do. It will make you reporting more efficient and happier customers. Only caveat is ensure that your summaries are not designed for a small set of reports..., and that your periodic snapshop always reconcile back to your atomic fact table.


rademola

Posts : 9
Join date : 2010-12-21

Back to top Go down

Loading data from one fact to another summary fact Empty Re: Loading data from one fact to another summary fact

Post  Jeff Smith Thu Jan 06, 2011 11:41 am

You can even load the aggregate from many fact tables as long as the grains are the same.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

Loading data from one fact to another summary fact Empty Re: Loading data from one fact to another summary fact

Post  rschulz01 Wed Aug 10, 2011 11:11 am

Would one model this summary table as a stand-alone table or as a fact table with the same dimensions as the original fact table?

Thanks in advance for your reply.

Rick

rschulz01

Posts : 5
Join date : 2011-07-26

Back to top Go down

Loading data from one fact to another summary fact Empty Re: Loading data from one fact to another summary fact

Post  ngalemmo Wed Aug 10, 2011 11:32 am

rschulz01 wrote:Would one model this summary table as a stand-alone table or as a fact table with the same dimensions as the original fact table?

Thanks in advance for your reply.

Rick

It would be a fact table with the same or fewer dimensions.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Loading data from one fact to another summary fact Empty Re: Loading data from one fact to another summary fact

Post  Mike Honey Wed Aug 10, 2011 11:59 pm

Hi Jamie,

Personally I would take the snapshot into a separate fact table, but avoid aggregating it. While this may seem redundant, it actually speeds the design / build / test effort (e.g. snapshot table columns = source table columns + As_At_Date, with simple ETL), and also builds in more flexibility for future (unknown) requirements.

Good luck!
Mike
Mike Honey
Mike Honey

Posts : 185
Join date : 2010-08-04
Location : Melbourne, Australia

http://www.mangasolutions.com

Back to top Go down

Loading data from one fact to another summary fact Empty Re: Loading data from one fact to another summary fact

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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