Microsoft
70-463 · Question #102
70-463 Question #102: Real Exam Question with Answer & Explanation
The correct answer is D: Script Component. When the standard Conditional Split transformation is not available as an answer choice, the Script Component configured as a transformation is the correct tool for routing rows to different outputs based on custom logic such as product code evaluation.
Question
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 SQL Azure. 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?
Options
- ASource Assistant
- BAudit
- CDestination Assistant
- DScript Component
Explanation
When the standard Conditional Split transformation is not available as an answer choice, the Script Component configured as a transformation is the correct tool for routing rows to different outputs based on custom logic such as product code evaluation.
Common mistakes.
- A. Source Assistant is a design-time helper for adding source adapters to a data flow; it does not participate in row-level transformation or routing logic.
- B. The Audit transformation appends system-level metadata columns (such as package name or machine name) to each row and does not provide the ability to split or route rows to separate outputs.
- C. Destination Assistant is a design-time helper for adding destination adapters to a data flow; it does not inspect row content or route rows between processing paths.
Concept tested. SSIS Script Component for custom row routing in data flow
Community Discussion
No community discussion yet for this question.