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

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

A lookup created using a pipeline which contains a target

A lookup cache split over pipelines of a partitioned mapping

A lookup associated with the Source Qualifier or an Application source such as JMS or SAP

A pipeline lookup does not exist

Reject reason

Column Indicator

Overflow Indicator

Row Indicator

Dynamic MQ Series target

MS target

Relational target

XML target

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

Expression and Update Strategy

Update Strategy

Update Strategy and Lookup

Expression, Aggregator, and Update Strategy

2 -Due to the line on the left hand side of the picture

13 -Based on all of the links entering the Source Qualifier

3 -Based on the all of the links between the Source Qualifier and the next transformation

Unknown - We need to know how many columns the target has