Informatica PR000041 Dumps

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

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

No

Yes

Yes, but only if the port being searched Is sorted first

Yes, but only if the port is downstream of a router transformation

A UDF name can contain letters, numbers and underscores

Can be used in mappings and transformations however not in mapplets

Can be reused from a shared folder as shortcut

Can contain Java code snippets

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

Check the Fail Parent if this task fails option box on the session task

Use a Control Task with a Control Option setting of Fail Me

Use an assignment task to call the ERROR() function

Use a command task to set the value of $RC to a negative number

1

2

3

4

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

Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS

PowerCenter connections may be created In either the Administrator or the Workflow Manager

MRS connections may be created in either the Workflow Manager or the Administrator

Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories