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.
Multicast
B.
Conditional Split
C.
Script Task
D.
Data Conversion
B
No such thing as a Script Task data flow transformation.
B
Question: “… need to enable separate processing streams for a subset of rows based on the source” – Conditional Split cam made separete stream by condition
product code…
Not C, because question not about Data Flow transformation for “special processing logic in
the data flow”
But other thing – question 168(there defintly “Script Component”)
B
B. Conditional Split
Normally I don’t disagree with Koala, but here I will go with “C”.
The question wants “special processing logic in the data flow”. You cannot have processing within the conditional split.
pb7788, please see http://www.bimonkey.com/2009/09/the-script-transformation-part-1-a-simple-transformation/
The answer is B. Who says you can’t have ‘special processing logic’ with Conditional Split?!
As part of it’s “conditional processing”, it can perform Mathematical, String, Date/Time, and NULL functions; it even has a huge collection of TypeCast & Maths Operators!!
The question hints B and B is the right answer.
No such thing as a Script Task data flow transformation it’s Script Component , so B will be the logical choice.
B