SSIS Best Practices
Posted on 2016-09-12
I am required to develop a data warehouse. As this would be my first project so i would need a bit of help from you guys.
Right! I have been reading about the good data warehousing practices. I have got few questions
i will be loading the data from three data sources so according to what i have read am i right in assuming that i will be pulling everything in my staging tables first?
Where would i handle the slowly changing dimensions in both staging and the data warehouse dimension tables?
How would i handle the incremental load? is it again same enabling CDC on OLTP and then in data warehouse?