PR000041 Practice Exam Questions with Answers PowerCenter Data Integration 9.x:Developer Specialist Certification

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

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

A lookup cannot be an active transformation

When the lookup is configured to return multiple rows

A lookup is always active

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

Expression, Router, Joiner

Update Strategy, Expression, Aggregator

Stored Procedure, Joiner, Router

Router, Update Strategy, Joiner

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