Which of the following are supported file types, from which, an XML definition can be imported? Choose 3 answers

A. XML

B. XSD

C. DTD

D. DSDL

An Update Strategy transformation has the Forward Rejected Rows attribute unchecked. Which statement is correct and true?

A. Records that are tagged for rejection are projected downstream to the next transformation so long as the ports are connected properly

B. Records that are tagged for rejection are dropped and not projected downstream to the next transformation

C. The Forward Rejected Rows attribute cannot be cleared after the transformation is created

D. The Forward Rejected Rows attribute is only applicable when records are tagged for rejection upstream of the Update Strategy transformation

Which statement on workflows is correct?

A. In a default configuration, a workflow must contain at least one session task

B. A workflow can contain multiple start points

C. In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions

D. Another workflow cannot be executed from within a workflow

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

Which of the following is not a Transaction Control Variable?

A. TC_CONTINUE_TRANSCTION

B. TC_COMMIT_TRANSACTION

C. TC_ROLLBACK_BEFORE

D. TC COMMIT AFTER

Referring to the Java transformation: select the statement below which is correct and true.

A. The Integration Service starts a JVM that executes the byte code to process data

B. PowerCenter requires an Eclipse Java Development Environment for the Java transformation

C. No Third Party Java API's are supported in the Java transformation

D. The Java transformation icon in PowerCenter Designer resembles a coffee bean

What does the function SETVARIABLE ($$Variable, value) do?

A. Assign the minimum value of the two to $$Variable

B. Assign the maximum value of the two to $$Variable

C. Allows the assignment of a value to a parameter

D. Assign the value to $$Variable, unless the value is null

Based upon the graphic below, which answer correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid)

· Workflows > Start Workflow A. AII objects displayed will be executed

B. The Start task only will be executed

C. The Start task and the link will execute, while the session task will wait to execute

D. The Start task and link only will be execute

Which of the following PowerCenter applications is browser-based in the Informatica 9.x environment?

A. Repository Manager

B. Informatica Administrator

C. Workflow Monitor

D. Workflow Manager

A Router transformation has the following group filter conditions:

Group A: InputValue = 2

Group B: InputValue > 1

Default group

The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

A. If InputValue = 2, the output will be routed to Group A only

B. If InputValue = 2, the output will be routed to both groups A and B

C. If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

D. Any positive number values other than 1 or 2 will be routed to the Default group