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

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

Answer:



Leave a Reply 0

Your email address will not be published. Required fields are marked *