Independence Day Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

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

Demo: 10 questions
Total 70 questions

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

Question 1

Which one of the following transformations may be unconnected In a valid mapping? (choose one)

Options:

A.

Lookup, stored procedure, external procedure

B.

Lookup, stored procedure, Java

C.

Java, lookup, transaction control

D.

Transaction control, Java, lookup

Question 2

A Router transformation has the following group filter conditions:

  • Group A: InputValue = 2
  • Group B: InputValue > 1
  • Default group

The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

Options:

A.

If InputValue = 2, the output will be routed to Group A only

B.

If InputValue = 2, the output will be routed to both groups A and B

C.

If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

D.

Any positive number values other than 1 or 2 will be routed to the Default group

Question 3

Given a Union transformation with 2 input groups, which statement is correct and true?

Options:

A.

Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.

B.

Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.

C.

When merging the 2 groups of data together, the Union transformation will remove duplicate rows.

D.

The port names in each input group can be named the same.

Question 4

When would a Lookup transformation be classified as active?

Options:

A.

When the setting for lookup policy on multiple match is Use Any Value

B.

A lookup cannot be an active transformation

C.

When the lookup is configured to return multiple rows

D.

A lookup is always active

Question 5

In which of the following selections are all of the transformations active?

Options:

A.

Expression, Router, Joiner

B.

Update Strategy, Expression, Aggregator

C.

Stored Procedure, Joiner, Router

D.

Router, Update Strategy, Joiner

Question 6

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

Options:

A.

lnput

B.

Output

C.

Variable

D.

Return

Question 7

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

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

The user creates a mapping by using aggregator transformation. The aggregator transformation receives sorted input from sorted transformation. What is the dafault partition type for aggregator transformation?

Options:

A.

Pass-through

B.

Hash auto-keys

C.

Not a valid partition points

D.

Based on the transformation scope

Question 9

Which of these statements on worklets is correct?

Options:

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

Question 10

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

Options:

A.

When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled

B.

When transformation scope is set to a value of transaction, the sorter will sort on every record in the pipeline before it releases any data. The intermediate sort file will have markers for each transaction.

C.

If the distinct check box is not checked, the sorter will produce one record per unique key

D.

The Sorter transformation will utilize database indexes from the source database to perform the sort

Demo: 10 questions
Total 70 questions