Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

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


380 Students Passed

96% Average Score

92% Same Questions
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

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

Questions # 2:

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

Options:

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

Questions # 3:

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

Questions # 4:

Which of the following PowerCenter applications is browser-based in the Informatica 9.x environment?

Options:

A.

Repository Manager

B.

Informatica Administrator

C.

Workflow Monitor

D.

Workflow Manager

Questions # 5:

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

Options:

A.

Expression and Update Strategy

B.

Update Strategy

C.

Update Strategy and Lookup

D.

Expression, Aggregator, and Update Strategy

Questions # 6:

Which statement on workflows is correct?

Options:

A.

In a default configuration, a workflow must contain at least one session task

B.

A workflow can contain multiple start points

C.

In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions

D.

Another workflow cannot be executed from within a workflow

Questions # 7:

The word FALSE is a valid Filter transformation condition?

Options:

A.

True

B.

False

Questions # 8:

What is a pipeline lookup transformation?

Options:

A.

A lookup created using a pipeline which contains a target

B.

A lookup cache split over pipelines of a partitioned mapping

C.

A lookup associated with the Source Qualifier or an Application source such as JMS or SAP

D.

A pipeline lookup does not exist

Questions # 9:

How does a single joiner transformation join data?

Options:

A.

From 2 pipeline inputs

B.

From 3 pipeline inputs

C.

From n number of pipeline inputs assuming you have purchased the N-Joiner Option

D.

none of the above

Questions # 10:

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

Options:

A.

The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

B.

The transformation's name or the tracing level

C.

The transformation's name, one of its port's default values or the tracing level

D.

The transformation's name is the only attribute that can be changed

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
TOP CODES

TOP CODES

Top selling exam codes in the certification world, popular, in demand and updated to help you pass on the first try.