1. Home
  2. Informatica
  3. Informatica Certified Professional ICP Program
  4. PR000041
  5. PowerCenter Data Integration 9.x:Developer Specialist Questions and Answers

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

 Informatica Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

Which of the following are supported file types, from which, an XML definition can be imported? Choose 3 answers

Options:
A.

XML

B.

XSD

C.

DTD

D.

DSDL

Expert Solution
Questions # 2:

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

Options:
A.

ROUND

B.

TRUNC

C.

INSTR

D.

CONCAT

Expert Solution
Questions # 3:

Which is the correct priority of assigning a mapping variable?

Options:
A.

Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value

B.

Session parameter file, workflow parameter file, repository value, declared initial value

C.

Repository value, workflow parameter file, pre-session assignment, session parameter file, default value

D.

Repository value, declared initial value, default value

Expert Solution
Questions # 4:

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

Expert Solution
Questions # 5:

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

Options:
A.

Option A

B.

OptionB

C.

OptionC

D.

OptionD

Expert Solution
Questions # 6:

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)

Options:
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

Expert Solution
Questions # 7:

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

Question # 7

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

Options:
A.

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

B.

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

C.

This picture depicts a SQL UNION operation

D.

This picture depicts an Informatica Homogeneous Join

Expert Solution
Questions # 8:

What function could be used to exchange 'i' with 'I' in the COMPANY port given the following expression?

functionname{1, COMPANY, 'i' , 'I')

Options:
A.

CHOOSE

B.

REPLACECHR

C.

REG_REPLACE

D.

INSTR

Expert Solution
Questions # 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

Expert Solution
Questions # 10:

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

Expert Solution
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions