New Year Special Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Informatica PR000041 PowerCenter Data Integration 9.x:Developer Specialist Exam Practice Test

Page: 1 / 7
Total 70 questions

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

Question 1

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

Options:

A.

Infasetup

B.

infacmd

C.

pmcmd

D.

pmrep

Question 2

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

Options:

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

Question 3

By default workflows always have a run status of succeeded. Identify the methods to change the run status of the workflow. For the puposes of this question, assume there are no worklets in the workflow.

Options:

A.

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

B.

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

C.

Use an assignment task to call the ERROR() function

D.

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

Question 4

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

Options:

A.

Pipeline A

B.

Pipeline B

C.

Both Pipelines should be cached for performance reasons

D.

Pipeline B if and only if Pipeline A is sorted

Question 5

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

Options:

A.

Dynamic MQ Series target

B.

MS target

C.

Relational target

D.

XML target

Question 6

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

Question # 6

Options:

A.

Option A

B.

OptionB

C.

OptionC

D.

OptionD

Question 7

Given the picture shown below:

Question # 7

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

Options:

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

Question 8

If after running a session task, it has been determined that the incorrect mapping was run for that session task, which of the following actions could be attempted?

Options:

A.

Edit the session task and from the General tab, choose the correct mapping to reassociate with the session task, then Save and rerun the process

B.

At run time, when the workflow is executed, chose the session task with the correct mapping associated

C.

Edit the session task and from the Mapping tab, choose the correct mapping to reassociate with the session ask, then Save and rerun the process

D.

None of the above

Question 9

When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)

Options:

A.

Filter, Joiner, Rank

B.

Union, Filter, Aggregator

C.

Rank, Lookup, Aggregator

D.

Joiner, Rank, Sorter

Question 10

Which command line tool would you use to execute a workflow?

Options:

A.

infasetup

B.

infacmd

C.

pmcmd

D.

pmrep

Page: 1 / 7
Total 70 questions