Labour Day Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Informatica
  3. Informatica Certified Professional ICP Program
  4. PR000041 - PowerCenter Data Integration 9.x:Developer Specialist

Informatica PR000041 PowerCenter Data Integration 9.x:Developer Specialist Exam Practice Test

Demo: 10 questions
Total 70 questions
Get PR000041 Full Access Download PR000041 PDF

PowerCenter Data Integration 9.x:Developer Specialist Questions and Answers

Question 1

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

Question 2

Which one of the following transformations may be unconnected In a valid mapping? (choose one)

Options:

A.

Lookup, stored procedure, external procedure

B.

Lookup, stored procedure, Java

C.

Java, lookup, transaction control

D.

Transaction control, Java, lookup

Question 3

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

Options:

A.

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

B.

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

C.

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

D.

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

Question 4

Assuming that the Master Pipeline has 5 fields, two of which are part of the join condition and that all fields are connected downstream to the next transformation, how many fields are in the index and data cache files?

Options:

A.

5 fields are in the index cache and 3 are in the data cache

B.

3 fields are in the index cache and 2 fields are in the data cache

C.

2 fields are in the index cache and 3 fields are in the data cache

D.

2 fields are in the index and 5 fields are in the data cache

Question 5

Which of the following is not a Transaction Control Variable?

Options:

A.

TC_CONTINUE_TRANSCTION

B.

TC_COMMIT_TRANSACTION

C.

TC_ROLLBACK_BEFORE

D.

TC COMMIT AFTER

Question 6

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

Options:

A.

True

B.

False

Question 7

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:

A.

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

B.

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

C.

Use an assignment task to call the ERROR() function

D.

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

Question 8

Referring to the Java transformation: select the statement below which is correct and true.

Options:

A.

The Integration Service starts a JVM that executes the byte code to process data

B.

PowerCenter requires an Eclipse Java Development Environment for the Java transformation

C.

No Third Party Java API's are supported in the Java transformation

D.

The Java transformation icon in PowerCenter Designer resembles a coffee bean

Question 9

The word FALSE is a valid Filter transformation condition?

Options:

A.

True

B.

False

Question 10

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

Options:

A.

DELETE

B.

GET

C.

POST

D.

PUT

Load More PR000041 Questions
Demo: 10 questions
Total 70 questions
Get PR000041 Full Access Download PR000041 PDF