1) 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 2

Subject:Computer SciencePrice:4.87 Bought7

Share With

1) 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

2. 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

3. 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

4. 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

5. 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