Question 1

Which of the following techniques could be used to filter data read from a flat file source?

Options :

A : Create a valid condition in the Filter attribute of the flat file-s Source Qualifier

B : Place a Filter transformation directly after the flat file-s Source Qualifier

C : An Expression transformation with an output port-s expression defined to filter records

D : An Expression transformation with all of the output port-s default values set to blank

Answer: B

Question 2

Which is the correct priority of assigning a mapping variable?

Options :

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

Answer: A

Question 3

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

Options :

A : lnput

B : Output

C : Variable

D : Return

Answer: A,B,D

Question 4

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

Options :

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

Answer: B

Question 5

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

Options :

A : Expression and Update Strategy

B : Update Strategy

C : Update Strategy and Lookup

D : Expression, Aggregator, and Update Strategy

Answer: B