Loading Dimensions Tracking History

Goal: Track history of data. A special type of dimension table tracks historic data (slowly changing dimensions type 2 and higher). For existing records, these tables expect an update and an insert.

Callout	See
1	Task Group
2
3	Performing Update and Upsert Operations Using a SQL Transformation Project
4	Performing Insert Operations Using a SQL Transformation Project