PR000041 Online Practice Questions and Answers

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

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?

A. Pass-through

B. Hash auto-keys

C. Not a valid partition points

D. Based on the transformation scope

A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)

A. Read permissions on the two folders

B. Read permissions on the two folders as well as have both folders opened

C. Full access (Read, Write and Execute permissions) on both folders

D. Mappings cannot be compared across folders using PowerCenter Designer

When would a Lookup transformation be classified as active?

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

B. A lookup cannot be an active transformation

C. When the lookup is configured to return multiple rows

D. A lookup is always active

Of the statements below, which best describes the underlying process taken when a user connects to a PowerCenter Repository Service for the first time? For the puposes of this question, the PowerCenter Developer is the only PowerCenter client application running, there are 2 nodes in the domain, node 1 is a gateway node and node 2 is a worker node. The PowerCenter Repository Service is running on the worker node.

A. The user connects directly and immediately to the Repository Service

B. The user connects to the service manager of the gateway node, and after authentication and authorization, is re- Assigned to the Repository Service

C. The user connects to the service manager of the worker node that is running the Repository Service, is then authenticated, authorized, and connected to the PowerCenter Repository Service

D. The user first connects to the PowerCenter Integration Service and then after authentication and authorization, is connected to the PowerCenter Repository Service

Referring to the SQL Transformation: which statements is correct and true.

A. The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline

B. The SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next

C. In PowerCenter 9 the SQL transformation, in query mode, can only be active

D. When you bind a parameter to an input port, you identify the port by name in the query. The SQL Editor encloses the name in exclamation question marks (!)

Can you use a Decode function to perform multiple searches based on a single search value?

A. No

B. Yes

C. Yes, but only if the port being searched Is sorted first

D. Yes, but only if the port is downstream of a router transformation

Refering to the Lookup transformation, which statement is correct and true?

A. The lookup condition defines how much memory each of the two caches will consume

B. The lookup condition defines the fields that are used in the search of the data

C. The lookup condition is limited to only the equal operator

D. The lookup condition is designated in the ports tab interface via the "L" check box

Referring to the Sequence Generator transformation, which statement is correct and true?

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

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

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

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

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

A. Dynamic MQ Series target

B. MS target

C. Relational target

D. XML target

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

A workflow has a session task. Both workflow and session each have been assigned a different parameter file. Which value will be set for $$ParameterValue in the session when using the following two parameter files?"

Workflow Parameter file: [Global] $$ParameterValue=l [Session] $$ParameterValue=2

Session Parameter file: [Global] $$ParameterValue=3 [Session] $$ParameterValue=4

A. 1

B. 2

C. 3

D. 4

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:

Identify all of the true and correct statements listed below. Choose 2 answers

A. This picture depicts a join that will be processed within the Informatica PowerCenter engine

B. This picture depicts a join that will be processed in a database

C. This picture depicts a SQL UNION operation

D. This picture depicts an Informatica Homogeneous Join

The word FALSE is a valid Filter transformation condition?

A. True

B. False

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

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