Hi all,

Anyone can suggest a good resource tutorial documentation on Slowly Changing Dimensions (SCDs)? More specifically, how to design TSQL queries dealing with SCDs etc and not using software like ETL etc, just MS SQL server studio to query tables. Would also like some documentation on designing history tables to keep track of all updates/inserts/deletes etc. Thanks