HOTSPOT
You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer
dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last Extract,
Transform and Load (ETL) process execution. You need to use the least amount of development effort to
achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in the answer
area.)
Which transformation should you use?
HOTSPOT
You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer
dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last Extract,
Transform and Load (ETL) process execution. You need to use the least amount of development effort to
achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in the answer
area.)