How to populate custom fact table with core facts

View previous topic View next topic Go down

How to populate custom fact table with core facts

Post  dalmada on Tue Nov 19, 2013 5:38 am

Hi,
I am trying to setup a custom/specific checking account table fact as suggested in "The Data WareHouse toolkit", and would like your opinion on best approach
to populate core facts in this custom fact table using SSIS as ETL tool.
Core fact table is obtained almost directly from source and include all customer accounts.
Custom facts are obtained from aggregate transformations on transactions/month and are both CPU/memory intensive. As so we first extract these transactions from source system and then perform aggregate transformations for each checking account. The question arises on when and how to load these along with core facts ?
 
Regards
david

dalmada

Posts : 3
Join date : 2013-07-28

View user profile

Back to top Go down

Re: How to populate custom fact table with core facts

Post  BoxesAndLines on Tue Nov 19, 2013 8:58 am

You load them at the same time. What you don't want to do is two passes to load the fact table.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: How to populate custom fact table with core facts

Post  dalmada on Tue Nov 19, 2013 10:29 am

Hi BoxesandLines,
In this case I would ( in SSIS ) repeat the core flow pipeline ( multicast updating and inserting new facts) and then merge with custom facts, or merge before and then repeat flow pipeline with all facts but updating and inserting only relevant facts for each fact table ?

Thanks for your reply
David

dalmada

Posts : 3
Join date : 2013-07-28

View user profile

Back to top Go down

Re: How to populate custom fact table with core facts

Post  BoxesAndLines on Tue Nov 19, 2013 11:11 am

That I would not be qualified to answer.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: How to populate custom fact table with core facts

Post  dalmada on Tue Nov 19, 2013 11:31 am

Thank you anyway.
In your experience do you load core fact table and custom fact table at same time? How did you do?


dalmada

Posts : 3
Join date : 2013-07-28

View user profile

Back to top Go down

Re: How to populate custom fact table with core facts

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