A. Edit the session task and from the Mapping tab, choose the correct mapping to reassociate with the session ask, then Save and rerun the process

B. None of the above

C. Edit the session task and from the General tab, choose the correct mapping to reassociate with the session task, then Save and rerun the process

D. At run time, when the workflow is executed, chose the session task with the correct mapping associated

A. As the only object In the mapping

B. As a Pre-Session SQL command

C. As a Post-Session SQL command

D. From an expression

A. The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence

B. The Sequence Generator contains a single input port that represents the initial starting point of the sequence

C. The NextVal column produces the next number in the sequence

D. The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

A. Repository value, declared initial value, default value

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

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

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

A. A lookup created using a pipeline which contains a target

B. A lookup cache split over pipelines of a partitioned mapping

C. A pipeline lookup does not exist

D. A lookup associated with the Source Qualifier or an Application source such as JMS or SAP

A. The port names in each input group can be named the same.

B. When merging the 2 groups of data together, the Union transformation will remove duplicate rows.

C. 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.

D. Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.

A. A lookup is always active

B. When the setting for lookup policy on multiple match is Use Any Value

C. When the lookup is configured to return multiple rows

D. A lookup cannot be an active transformation