Staging Strategy and CDC

View previous topic View next topic Go down

Staging Strategy and CDC

Post  veskojl on Tue Jul 26, 2011 6:55 am

Hi,
I have few questions related to the design of a DW with type 1 dimensions, but what concerns me is the loading of the fact tables.

What should be the staging strategy for the tables from which facts are loaded?
Should they be truncated on every run or insert/updated?
And when CDC should be applied before the staging or after that when loading the facts?
Basically how to prepare the staging area for loading the fact tables?


Last edited by veskojl on Tue Jul 26, 2011 11:06 am; edited 1 time in total

veskojl

Posts : 11
Join date : 2011-07-21

View user profile

Back to top Go down

Re: Staging Strategy and CDC

Post  ngalemmo on Tue Jul 26, 2011 10:30 am

There isn't any one best strategy for staging. It is highly dependent on the nature of the sources. In general the staging area is transient, truncate and load of staging tables is common.

As far as CDC goes, if your source has a mechanism to identify change from the last extract, then, by all means, use it. The less data pulled into staging the better.
avatar
ngalemmo

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

View user profile http://aginity.com

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