Building ETLs for dimensions in SQL Server 2000 DTS almost always required writing time consuming ActiveX scripts for tasks such as checking and upserting records. With the entry of SQL Server 2005's Integration Services, these tasks have now become a series of clicks and drags. The article Populating Dimension Tables with the SCD Task, talks about how the Slowly Changing Dimension task allows you to create quick ETLs with ease. Please feel free to comment and rate on this article.
What do you think about this article
Excellent (50%)
Good (50%)
Average (0%)
Fair (0%)
Poor (0%)
Gogula G. Aryalingam (MVP - SQL Server)
