Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Informatica
Informatica Certified Professional ICP Program
PR000041
PowerCenter Data Integration 9.x:Developer Specialist Questions and Answers

Pass the Informatica Certified Professional ICP Program PR000041 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam PR000041 Premium Access

View all detail and faqs for the PR000041 exam

Go to Exam

695 Students Passed

91% Average Score

97% Same Questions

Viewing page 2 out of 3 pages

Viewing questions 11-20 out of questions

Questions # 11:

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:

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

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

Use an assignment task to call the ERROR() function

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

Answer

Questions # 12:

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 # 12

Options:

Option A

OptionB

OptionC

OptionD

Answer

A, C

Questions # 13:

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:

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

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

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

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

Answer

Questions # 14:

Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:

Question # 14

Identify all of the true and correct statements listed below. Choose 2 answers

Options:

This picture depicts a join that will be processed within the Informatica PowerCenter engine

This picture depicts a join that will be processed in a database

This picture depicts a SQL UNION operation

This picture depicts an Informatica Homogeneous Join

Answer

B, C

Questions # 15:

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

Options:

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

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

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

Answer

Questions # 16:

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

Options:

infasetup

infacmd

pmcmd

pmrep

Answer

Questions # 17:

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

Options:

A worker node does not use a service manager

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

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.

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

Answer

Questions # 18:

Referring to a lookup transformation: Which of the following statements are true and correct?

Options:

The caching of a flat file is optional if the data in the flat file is sorted

The lookup index cache file contains a searchable index of the records based on the lookup condition

When lookup caching is unchecked, PowerCenter will read from a locally stored cache file

The data cache contains all of the fields in the lookup transformation

Answer

Questions # 19:

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

Options:

A mapplet can contain a target definition

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

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

A mapplet can contain a Normalizer transformation

Answer

Questions # 20:

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)