You are designing a SQL Server Integration Services (SSIS) data flow to load sales
transactions from a source system into a data warehouse hosted on Windows Azure SQL
Database. One of the columns in the data source is named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in
the data flow.
You need to enable separate processing streams for a subset of rows based on the source
product code.
Which data flow transformation should you use?
A.
Source Assistant
B.
Destination Assistant
C.
Audit
D.
Script Component
Explanation:
Script Component Transformation:
The transformation that uses script to extract, transform, or load data.
Note:
* SQL Server Integration Services provides three different types of data flow components:
sources, transformations, and destinations. Sources extract data from data stores such as
tables and views in relational databases, files, and Analysis Services databases.
Transformations modify, summarize, and clean data. Destinations load data into data stores
or create in-memory datasets.
Incorrect:
Not A, Not B: No Data Transforms called Source Assistant or Destination Assistant
Not C: Not related to auditing
Conditional Split
Ideally, Conditional Split; but since it’s not included in the option? You have to script the “special processing logic” using a Script Component
181
http://www.aiotestking.com/microsoft/which-data-flow-transformation-should-you-use-7/
Here are the right choices.