question archive 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
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
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
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) Lookup
5) a) Sequence Container
Step-by-step explanation
1) It is the merge join which is meant for projection of the joined table which are sorted on the join column. This is much faster and consumes less memory than that of the hash join.
2) This would take up 2 data sets.
3) The aggregator transformation is considered to be an active transformation meant for performing the aggregate calculation such as sum, average etc
4) This is considered to be a much useful transformation as it would pull in some of the data from that of multiple sources.
5) The sequence container would define the control flow which is the subset, and here it has a group of packages as many separate control flow which would provide the scope for the variable where the related task as well as containers are being used.
