Question

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

Answer 1

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.)