Latest PR000041 Exam Questions

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

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

Character day of week, character day of month, and character day of year respectively

Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight)
respectively

Each produces numerical day of week

Numerical day of week, day of month, and day of year respectively

ROUND

TRUNC

INSTR

CONCAT

True

False

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

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

Repository Manager

 Informatica Administrator

Workflow Monitor

Workflow Manager

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

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