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

How to populate custom fact table with core facts

2 posters

Go down

How to populate custom fact table with core facts Empty How to populate custom fact table with core facts

Post  dalmada 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

Back to top Go down

How to populate custom fact table with core facts Empty Re: How to populate custom fact table with core facts

Post  BoxesAndLines 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.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

How to populate custom fact table with core facts Empty Re: How to populate custom fact table with core facts

Post  dalmada 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

Back to top Go down

How to populate custom fact table with core facts Empty Re: How to populate custom fact table with core facts

Post  BoxesAndLines Tue Nov 19, 2013 11:11 am

That I would not be qualified to answer.
BoxesAndLines
BoxesAndLines

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

Back to top Go down

How to populate custom fact table with core facts Empty Re: How to populate custom fact table with core facts

Post  dalmada 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

Back to top Go down

How to populate custom fact table with core facts Empty Re: How to populate custom fact table with core facts

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