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

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

Expression and Update Strategy

Update Strategy

Update Strategy and Lookup

Expression, Aggregator, and Update Strategy

A mapplet can contain a target definition

A mapplet can contain a source definition as well as a source qualifier

Every mapplet must have at least 1 Input transformation as well as 1 Output transformation

A mapplet can contain a Normalizer transformation

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

infasetup

infacmd

pmcmd

pmrep

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

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.

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

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

You can place an aggregate function in a variable port

You can add a filter condition to calculate values for specific rows In the selected ports

You can use operators to perform arithmetic within the function

You can calculate a single value for all rows in a group

Dynamic MQ Series target

MS target

Relational target

XML target

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

Pass-through

Hash auto-keys

Not a valid partition points

Based on the transformation scope

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

True

False

lnput

Output

Variable

Return

Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST

Describes an INNER JOIN between PRODUCT AND PRODUCT_COST

Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST

Can be created within Informatica PowerCenter

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

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

Create a valid condition in the Filter attribute of the flat file's Source Qualifier

Place a Filter transformation directly after the flat file's Source Qualifier

An Expression transformation with an output port's expression defined to filter records

An Expression transformation with all of the output port's default values set to blank

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