Labour Day Sale - Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 575363r9

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

PR000041 Sample Questions Answers

Questions 4

The HTTP Transformation supports which HTTP Methods? (Choose all that apply) Choose 2 answers

Options:

A.

DELETE

B.

GET

C.

POST

D.

PUT

Buy Now
Questions 5

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

Options:

A.

Pipeline A

B.

Pipeline B

C.

Both Pipelines should be cached for performance reasons

D.

Pipeline B if and only if Pipeline A is sorted

Buy Now
Questions 6

Which of following statements is valid for Dynamic lookups?

Options:

A.

Dynamic caching cannot be enabled on a lookup that returns multiple rows per search

B.

A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert

C.

A dynamic lookup must be cached and persistent

D.

It is possible to update and delete records in a dynamic lookup

Buy Now
Questions 7

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

Options:

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

Buy Now
Questions 8

Which of the following statments are valid for Active and Passive Transformations? Choose 2 answers

Options:

A.

A transformation is active if It rearranges the order of the rows in the pipeline

B.

A transformation is active if it does not change the number of rows in the pipeline

C.

Transformations can be active and passive at the same time

D.

A passive transformation will not change the number of rows in the pipeline

Buy Now
Questions 9

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

Options:

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

Buy Now
Questions 10

Which statement is correct regarding User-Defined Functions (UDF)?

Options:

A.

A UDF name can contain letters, numbers and underscores

B.

Can be used in mappings and transformations however not in mapplets

C.

Can be reused from a shared folder as shortcut

D.

Can contain Java code snippets

Buy Now
Exam Code: PR000041
Exam Name: PowerCenter Data Integration 9.x:Developer Specialist
Last Update: Apr 23, 2024
Questions: 70
$64  $159.99
$48  $119.99
$40  $99.99
buy now PR000041