Best method for incremental fact load (inserts and updates) using SSIS
3 posters
Page 1 of 1
Best method for incremental fact load (inserts and updates) using SSIS
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?
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
Re: Best method for incremental fact load (inserts and updates) using SSIS
You can use T-SQL Merge Statement if possible
selvaraman- Posts : 1
Join date : 2012-07-13
Re: Best method for incremental fact load (inserts and updates) using SSIS
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
Similar topics
» ETL Fact Load in SSIS
» Incremetal load from 1 fact to another fact
» Loading Fact table
» ETL for Fact load
» Inventory Fact Table: How to load it?
» Incremetal load from 1 fact to another fact
» Loading Fact table
» ETL for Fact load
» Inventory Fact Table: How to load it?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum