Which transformation should you use?

DRAG DROP
You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.
Issues concerning addresses are discovered in the data warehouse that you manage. Validation must
separate the addresses into three categories:
 Valid addresses
 Autocorrected addresses
 Invalid addresses
You need to enhance the SSIS packages to perform address validation by using an external service.
Which transformation should you use? (To answer, drag the appropriate transformation from the list of
options to the correct location or locations in the answer area.)

DRAG DROP
You use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.
Issues concerning addresses are discovered in the data warehouse that you manage. Validation must
separate the addresses into three categories:
 Valid addresses
 Autocorrected addresses
 Invalid addresses
You need to enhance the SSIS packages to perform address validation by using an external service.
Which transformation should you use? (To answer, drag the appropriate transformation from the list of
options to the correct location or locations in the answer area.)

Answer:



Leave a Reply 1

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


CorvusAlpha

CorvusAlpha

DQS cleansing