Loading data from one fact to another summary fact

View previous topic View next topic Go down

Loading data from one fact to another summary fact

Post  Jamie on 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

View user profile

Back to top Go down

Re: Loading data from one fact to another summary fact

Post  hang on 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

View user profile

Back to top Go down

Re: Loading data from one fact to another summary fact

Post  rademola on 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

View user profile

Back to top Go down

Re: Loading data from one fact to another summary fact

Post  Jeff Smith on 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

View user profile

Back to top Go down

Re: Loading data from one fact to another summary fact

Post  rschulz01 on 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

View user profile

Back to top Go down

Re: Loading data from one fact to another summary fact

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Loading data from one fact to another summary fact

Post  Mike Honey on 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
avatar
Mike Honey

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

View user profile http://www.mangasolutions.com

Back to top Go down

Re: Loading data from one fact to another summary fact

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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