PR000041 Online Practice Questions and Answers

Which of the following Is NOT true of Aggregate functions?

A. You can place an aggregate function in a variable port

B. You can add a filter condition to calculate values for specific rows In the selected ports

C. You can use operators to perform arithmetic within the function

D. You can calculate a single value for all rows in a group

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression? functionname{1, COMPANY, 'i' , 'I')

A. CHOOSE

B. REPLACECHR

C. REG_REPLACE

D. INSTR

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

A. lnput

B. Output

C. Variable

D. Return

Which is the correct priority of assigning a mapping variable?

A. Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value

B. Session parameter file, workflow parameter file, repository value, declared initial value

C. Repository value, workflow parameter file, pre-session assignment, session parameter file, default value

D. Repository value, declared initial value, default value

In which of the following selections are all of the transformations active?

A. Expression, Router, Joiner

B. Update Strategy, Expression, Aggregator

C. Stored Procedure, Joiner, Router

D. Router, Update Strategy, Joiner

Two pipelines (A and 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?

A. Pipeline A

B. Pipeline B

C. Both Pipelines should be cached for performance reasons

D. Pipeline B if and only if Pipeline A is sorted

Which of the following statements regarding mapplets are correct and true?

A. A mapplet can contain a target definition

B. A mapplet can contain a source definition as well as a source qualifier

C. Every mapplet must have at least 1 Input transformation as well as 1 Output transformation

D. A mapplet can contain a Normalizer transformation

Which of the following statments are valid for Active and Passive Transformations? Choose 2 answers

A. A transformation is active if It rearranges the order of the rows in the pipeline

B. A transformation is active if it does not change the number of rows in the pipeline

C. Transformations can be active and passive at the same time

D. A passive transformation will not change the number of rows in the pipeline

A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than

1.

A. True

B. False

Which statement is correct regarding User-Defined Functions (UDF)?

A. A UDF name can contain letters, numbers and underscores

B. Can be used in mappings and transformations however not in mapplets

C. Can be reused from a shared folder as shortcut

D. Can contain Java code snippets