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

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

3 posters

Go down

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

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

Back to top Go down

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

Post  selvaraman Fri Jul 13, 2012 10:54 am

You can use T-SQL Merge Statement if possible

selvaraman

Posts : 1
Join date : 2012-07-13

Back to top Go down

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

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

Back to top Go down

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

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