PR000041 PowerCenter Data Integration 9.x:Developer Specialist Question and Answers

Lookup, stored procedure, external procedure

Lookup, stored procedure, Java

Java, lookup, transaction control

Transaction control, Java, lookup

The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

The transformation's name or the tracing level

The transformation's name, one of its port's default values or the tracing level

The transformation's name is the only attribute that can be changed

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

A workflow can contain multiple start points

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

Another workflow cannot be executed from within a workflow

lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced

If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced

If the lookup finds two records that match the search key, it will return two records

None of the above

No

Yes

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

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

A UDF name can contain letters, numbers and underscores

Can be used in mappings and transformations however not in mapplets

Can be reused from a shared folder as shortcut

Can contain Java code snippets

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