Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Informatica PR000041 - PowerCenter Data Integration 9.x:Developer Specialist

Informatica PR000041 Premium Access     Download Demo    
Page: 2 / 3
Total 70 questions

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

A.

Expression and Update Strategy

B.

Update Strategy

C.

Update Strategy and Lookup

D.

Expression, Aggregator, and Update Strategy

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

A.

The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

B.

The transformation's name or the tracing level

C.

The transformation's name, one of its port's default values or the tracing level

D.

The transformation's name is the only attribute that can be changed

Which command line tool would you use to import a workflow into a repository?

A.

Infasetup

B.

infacmd

C.

pmcmd

D.

pmrep

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

A.

If a transformation's Active property is cleared or not enabled, the transformation becomes passive

B.

A transformation is active if it does not change the number of rows in the pipeline

C.

Transformations can be active and passive at the same time

D.

A passive transformation will not change the number of rows in the pipeline

Which of the following statements regarding mapplets are correct and true?

A.

A mapplet can contain a target definition

B.

A mapplet can contain a source definition as well as a source qualifier

C.

Every mapplet must have at least 1 Input transformation as well as 1 Output transformation

D.

A mapplet can contain a Normalizer transformation

When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?

A.

The data from the detail pipeline Is used to build the cache files used In the join process

B.

The data from the master pipeline is used to build the cache files used in the join process

C.

The cache files are built according to a sql override found on the Joiner Properties tab

D.

The Joiner transformation uses the database to build the join result

Which of these statements on worklets is correct?

A.

Worklets can be nested

B.

A worklet must be a reusable object

C.

A worklet can be executed separately

D.

A worklet does not have to contain a Start task

Which of the following PowerCenter applications is browser-based in the Informatica 9.x environment?

A.

Repository Manager

B.

Informatica Administrator

C.

Workflow Monitor

D.

Workflow Manager

The word FALSE is a valid Filter transformation condition?

A.

True

B.

False

Refering to the Lookup transformation, which statement is correct and true?

A.

The lookup condition defines how much memory each of the two caches will consume

B.

The lookup condition defines the fields that are used in the search of the data

C.

The lookup condition is limited to only the equal operator

D.

The lookup condition is designated in the ports tab interface via the "L" check box