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: 1 / 3
Total 70 questions

Which is the correct priority of assigning a mapping variable?

A.

Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value

B.

Session parameter file, workflow parameter file, repository value, declared initial value

C.

Repository value, workflow parameter file, pre-session assignment, session parameter file, default value

D.

Repository value, declared initial value, default value

Given the picture shown below:

Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question.

The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST : Choose 2 answers

A.

Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST

B.

Describes an INNER JOIN between PRODUCT AND PRODUCT_COST

C.

Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST

D.

Can be created within Informatica PowerCenter

A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.

A.

True

B.

False

Which of the following techniques could be used to filter data read from a flat file source?

A.

Create a valid condition in the Filter attribute of the flat file's Source Qualifier

B.

Place a Filter transformation directly after the flat file's Source Qualifier

C.

An Expression transformation with an output port's expression defined to filter records

D.

An Expression transformation with all of the output port's default values set to blank

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? Choose 2 answers

A.

Option A

B.

OptionB

C.

OptionC

D.

OptionD

Which of the following is true about database connections?

A.

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

B.

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

C.

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

D.

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

Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

A.

True

B.

False

A user needs to compare mappings across two folders using the comparsion tool in PowerCenter Designer. What does the user account need in order to successfully complete the comparsion action? (Given that the user account has been granted the ability to use PowerCenter Designer)

A.

Read permissions on the two folders

B.

Read permissions on the two folders as well as have both folders opened

C.

Full access (Read, Write and Execute permissions) on both folders

D.

Mappings cannot be compared across folders using PowerCenter Designer

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

A.

Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox

B.

Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping

C.

Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down

D.

No

Given the picture shown below:

How many columns would be selected from the database using PowerCenter's generated sql statement?

A.

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

B.

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

C.

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

D.

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