Re: Slowly Changing Dimensions

Well from a theoretical standpoint, this is one approach:

1) Load your 'new' data into a staging table2) Use a SQL Minus operator to detect changes from this time period to the last (see SQL Functions, Operators, Expressions and Predicates PDF) and put only the changed records in a temp table.3) Depending on your need, use the records in the temp table from (2) to either perform scd type 2 or scd type 3 logic.