question archive Q1) Which of the following components joins the rows of two sorted inputs based on a defined join column and adds the column from each source? A
Q1) Which of the following components joins the rows of two sorted inputs based on a defined join column and adds the column from each source? A
Subject:AccountingPrice:2.87 Bought9
Q1) Which of the following components joins the rows of two sorted inputs based on a defined join column and adds the column from each source?
A. INNER Join B. MERGE join C. UNION ALL D.Concatenation E. Defined Join
Q2. Which component combines the rows of two similar sorted inputs, one on top of the other, based on defined sort key?
A. Lookup B. Merge C. Merge Join D.Multicast
Q3. Which transformation associates records based on defined groupings and generate calculations such as: SUM, MAX, MIN, and COUNT
A.Sort Transformation B. Pivot Transformation C. Unpivot Transformation D. Aggregate Transformation
Q4. Which transformation would be the most useful for rejoining previously split paths- for example, paths that were split upstream by a Conditional split?
A.Script Component B.Unsort C. Union D.Union All E.Lookup
Q5. Which component tool groups task into control flow that are subset of the package control flow, and allows you to apply transactions or assign logging to the container
A. Sequence Container B. For Loop Container C. For Each Loop Container D. First Container
Purchase A New Answer
Custom new solution created by our subject matter experts
GET A QUOTE
Answer Preview
Answer:
1) B ( Merge join)
2) B (Merge)
3) D (Aggregate transformation)
4) E (look up)
5) A (sequence Container)
