Want to refresh the Dim Table data periodically. What are all the possible way to achieve. 1. Create the staging check if records not exist then insert 2. Truncate the hole table then insert 3. Use lookup command check all the columns or key columns only Any other ways to do that Help on this Thanks

it depends on business requirements but we did lots of truncate the entire table and then insert without any problemsBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

As Uri wrote, its depents on your requirements. If you don't want to loose historic data, it's better to delete only the new comming keysand than store the whole comming data into the Dim table. This is the most way, I handle this.

If you want history, you can't truncate. You need to get your hands on The Data Warehouse Toolkit to understand how to load dimension tables properly - it's a definitive resource. There are a series of videos on how to load dimensions on this page, using the SCD Wizard, standard SSIS components, T-SQL MERGE, and the Dimension Merge SCD. Talk to me now on