PR000041 Exam Dumps : PowerCenter Data Integration 9.x:Developer Specialist

Dynamic caching cannot be enabled on a lookup that returns multiple rows per search

A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert

A dynamic lookup must be cached and persistent

It is possible to update and delete records in a dynamic lookup

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

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