70-463 · Question #145
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system. Depending on the value in a source colu
The correct answer is A. Conditional Split. The Conditional Split transformation evaluates a set of Boolean expressions against each incoming row and routes that row to the first output whose condition evaluates to true, with a default output for rows matching no condition. This is the SSIS equivalent of a CASE or IF-ELSE
Question
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data load strategy. The package reads data from a source system. Depending on the value in a source column, the package redirects rows to one of five different data flow paths. You need to add a data flow transformation to support the package redirection. Which data flow transformation should you use?
Options
- AConditional Split
- Bpjvot
- CMulticast
- DLookup
How the community answered
(24 responses)- A88% (21)
- B8% (2)
- D4% (1)
Explanation
The Conditional Split transformation evaluates a set of Boolean expressions against each incoming row and routes that row to the first output whose condition evaluates to true, with a default output for rows matching no condition. This is the SSIS equivalent of a CASE or IF-ELSE statement in a data flow. For routing rows to five different paths based on the value in a source column, Conditional Split is the correct choice. Multicast copies every row to all outputs simultaneously (no filtering). Lookup joins rows to a reference dataset. Pivot restructures normalized rows into a columnar format. None of the other options provide conditional routing logic.
Topics
Community Discussion
No community discussion yet for this question.