How to populate custom fact table with core facts
2 posters
Page 1 of 1
How to populate custom fact table with core facts
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
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
Re: How to populate custom fact table with core facts
You load them at the same time. What you don't want to do is two passes to load the fact table.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: How to populate custom fact table with core facts
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
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
Re: How to populate custom fact table with core facts
That I would not be qualified to answer.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: How to populate custom fact table with core facts
Thank you anyway.
In your experience do you load core fact table and custom fact table at same time? How did you do?
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
Similar topics
» non-additive facts in a fact table?
» Non additive facts in fact table
» Multiple facts in a fact table
» Textual Facts in the fact table
» Measures in Dimension?
» Non additive facts in fact table
» Multiple facts in a fact table
» Textual Facts in the fact table
» Measures in Dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum