PR000041 Online Practice Questions and Answers

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

When would a Lookup transformation be classified as active?

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

Referring to Informatica Domain Architecture, select the statement which is correct and true.

A. A worker node does not use a service manager

B. The OS process that is running after the service manager is started is called pmserver

C. The service manager on node 1 will directly monitor services on node 1 and node 2. This is why it is called the gateway manager.

D. Nodes within a domain are identified by their name, a hostname and portnumber

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

Referring to the Sequence Generator transformation, which statement is correct and true?

A. The NextVal column produces the next number in the sequence

B. The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence

C. The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

D. The Sequence Generator contains a single input port that represents the initial starting point of the sequence

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

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

1.

A. True

B. False

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

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

What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

A. ROUND

B. TRUNC

C. INSTR

D. CONCAT

In the TO_CHAR (date) function, what do the format strings D, DD, and DDD produce? (choose one)

A. Character day of week, character day of month, and character day of year respectively

B. Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight) respectively

C. Each produces numerical day of week

D. Numerical day of week, day of month, and day of year respectively