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:

Explanation:

Show Hint

Leave a Reply 2

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

Slazenjer_m

Slazenjer_m

Absolutely, DQS Cleansing!!

*Fuzzy Lookup (used for Identity mapping), benefits from a prior Lookup transformation
**Fuzzy Grouping (for De-duplication), benefits from a prior Aggregate transformation
***A Lookup transformation (in this scenario) should not exit into a Conditional Split, but instead into a MultiCast transormation.

Reply

Tanzila

Tanzila

DQS cleansing

Reply