Goal: Load dimension tables. Maintaining data in a dimension table typically requires inserting new and updating changed records (slowly changing dimensions type 1 and higher). This use case assumes that changed data is already staged in IQ.
Performing Insert Operations Using a SQL Transformation Project
Performing Update and Upsert Operations Using a SQL Transformation Project