Best method for incremental fact load (inserts and updates) using SSIS

View previous topic View next topic Go down

Best method for incremental fact load (inserts and updates) using SSIS

Post  manbat on Thu Jun 07, 2012 10:36 pm

I am aware that SSIS has SCD component which can be used to determine insert/update strategy.

When loading a fact table (incrementally), can we use the same SCD component or is there a better way to load fact tables?

manbat

Posts : 1
Join date : 2012-06-07

View user profile

Back to top Go down

Re: Best method for incremental fact load (inserts and updates) using SSIS

Post  selvaraman on Fri Jul 13, 2012 10:54 am

You can use T-SQL Merge Statement if possible

selvaraman

Posts : 1
Join date : 2012-07-13

View user profile

Back to top Go down

Re: Best method for incremental fact load (inserts and updates) using SSIS

Post  TheNJDevil on Fri Jul 13, 2012 11:15 am

Why would you want use the SCD on a fact table? Fact tables should be mostly inserts with virtually no updates (of course there are exceptions). I've just separated out the pure fact insert flow from the update flow and everything seems to run smoothely.

TheNJDevil

Posts : 68
Join date : 2011-03-01

View user profile

Back to top Go down

Re: Best method for incremental fact load (inserts and updates) using SSIS

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