70-463 · Question #77
You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for d
The correct answer is D. Union All E. Merge. Both Union All and Merge transformations combine rows from multiple input sources into a single output stream, which is exactly what is needed to merge two product source feeds into one destination table. Union All accepts multiple inputs in any sort order and passes all rows thr
Question
You are creating a SQL Server Integration Services (SSIS) package to retrieve product data from two different sources. One source is hosted in a SQL Azure database. Each source contains products for different distributors. Products for each distributor source must be combined for insertion into a single product table destination. You need to select the appropriate data flow transformation to meet this requirement. Which transformation types should you use? (Each answer represents a complete solution. Choose all that apply.)
Options
- ASlowly Changing Dimension
- Bpivot
- CLookup
- DUnion All
- EMerge
How the community answered
(70 responses)- A1% (1)
- B4% (3)
- C3% (2)
- D91% (64)
Explanation
Both Union All and Merge transformations combine rows from multiple input sources into a single output stream, which is exactly what is needed to merge two product source feeds into one destination table. Union All accepts multiple inputs in any sort order and passes all rows through without modification. Merge accepts exactly two inputs but requires both to be sorted on the same key - it merges them in sorted order. Either satisfies the requirement of combining two sources for a single destination. Option A (Slowly Changing Dimension) manages historical tracking of dimension attribute changes, not row combining. Option B (Pivot) rotates rows into columns. Option C (Lookup) enriches rows by matching against a reference dataset - it does not combine two full source datasets into one output stream.
Topics
Community Discussion
No community discussion yet for this question.