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
D. Script Component
The script component is a fall back answer. I’ve seen this question elsewhere and the real answer is conditional split