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

Assign the minimum value of the twoto $$Variable

Assign the maximum value of the two to $$Variable

Allows the assignment of a value to a parameter

Assign the value to $$Variable, unless the value is null

A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping

A user-defined event can be created a-d raised in one workflow and then used In another

A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.

A user-defined event can be created in either the Event Wait or Event Raise task

Expression and Update Strategy

Update Strategy

Update Strategy and Lookup

Expression, Aggregator, and Update Strategy

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

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

Option A

OptionB

OptionC

OptionD

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