small dimension DimBranch, there are only 3 columns - coutry,city,branch - three together is unique key
every time when package runs - just truncate table DimBranch - insert distinct coutry,city,branch into DimBranch from ...
easy and works nice, I always sure that all rows are came (new one, changed one and etc)
but would like to try use all benefits from SSIS like Slowly Changing Dimension
so, how to setup SCD in my case ? what is a business key ? I don't need to keep historical data, only update existing or insert new one
View Complete Post