Archive for the ‘SQL’ Category:
How to implement Slowly Changing Dimensions – Part 3. Using SSIS Dimension Merge SCD Component to load dimension data
August 23rd, 2012 / No Comments » / by admin
How to implement Slowly Changing Dimensions – Part 2. Using Checksum Transformation SSIS component to load dimension data
August 21st, 2012 / 4 Comments » / by admin



Yes, with some changes and additions e.g. found out that AI_REDACT is way to slow for high volumes, so I'd…