PR000041 Sample Questions Answers

A worker node does not use a service manager

The OS process that is running after the service manager is started is called pmserver

The service manager on node 1 will directly monitor services on node 1 and node 2. This is why it is called the gateway manager.

Nodes within a domain are identified by their name, a hostname and portnumber

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

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

Transformations can be active and passive at the same time

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

AII objects displayed will be executed

The Start task only will be executed

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

The Start task and link only will be execute

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

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

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

Repository value, declared initial value, default value

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

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

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

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

The user connects directly and immediately to the Repository Service

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

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

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

Repository Manager

Informatica Administrator

Workflow Monitor

Workflow Manager

Lookup, stored procedure, external procedure

Lookup, stored procedure, Java

Java, lookup, transaction control

Transaction control, Java, lookup

STATE

'CA'

NULL

Value of the PREVI0US_STATE port is based upon its declared default value

Expression and Update Strategy

Update Strategy

Update Strategy and Lookup

Expression, Aggregator, and Update Strategy

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

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

This picture depicts a SQL UNION operation

This picture depicts an Informatica Homogeneous Join

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

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

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

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 (!)

Decision

Assignment

Control

Command

The NextVal column produces the next number in the sequence

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

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

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

If a transformation's Active property is cleared or not enabled, the transformation becomes passive

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

Transformations can be active and passive at the same time

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

5 fields are in the index cache and 3 are in the data cache

3 fields are in the index cache and 2 fields are in the data cache

2 fields are in the index cache and 3 fields are in the data cache

2 fields are in the index and 5 fields are in the data cache

True

False

The caching of a flat file is optional if the data in the flat file is sorted

The lookup index cache file contains a searchable index of the records based on the lookup condition

When lookup caching is unchecked, PowerCenter will read from a locally stored cache file

The data cache contains all of the fields in the lookup transformation