QUESTION: 21

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1, 000, 000 records. Which pipeline should be designated the master pipeline?

Pipeline A
Pipeline B
Both Pipelines should be cached for performance reasons
Pipeline B if and only if Pipeline A is sorted

Answer(s): A

Reveal Solution Next Question

QUESTION: 22

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator

transformation?

Pass-through
Hash auto-keys
Not a valid partition points
Based on the transformation scope

Answer(s): B

Reveal Solution Next Question

QUESTION: 23

When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)

Filter, Joiner, Rank
Union, Filter, Aggregator
Rank, Lookup, Aggregator
Joiner, Rank, Sorter

Answer(s): D

Reveal Solution Next Question

QUESTION: 24

Given a Union transformation with 2 input groups, which statement is correct and true?

Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.
Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.
When merging the 2 groups of data together, the Union transformation will remove duplicate rows.
The port names in each input group can be named the same.

Answer(s): A

Reveal Solution Next Question

Free PR000041 Exam Braindumps (page: 7)

QUESTION: 21

QUESTION: 22

QUESTION: 23

QUESTION: 24

PR000041 Discussions & Posts