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

Filter, Joiner, Rank

Union, Filter, Aggregator

Rank, Lookup, Aggregator

Joiner, Rank, Sorter

lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced

If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced

If the lookup finds two records that match the search key, it will return two records

None of the above

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

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

Infasetup

infacmd

pmcmd

pmrep

Dynamic MQ Series target

MS target

Relational target

XML target

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