Informatica PR000041 ICP Exam Questions Instant Access

Question 1

Which of the following is not a Transaction Control Variable?

ATC_CONTINUE_TRANSCTION

BTC_COMMIT_TRANSACTION

CTC_ROLLBACK_BEFORE

DTC COMMIT AFTER

Answer : B

Question 2

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?

APipeline A

BPipeline B

CBoth Pipelines should be cached for performance reasons

DPipeline B if and only if Pipeline A is sorted

Answer : A

Question 3

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

ADynamic MQ Series target

BMS target

CRelational target

DXML target

Answer : B

Question 4

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

Ainfasetup

Binfacmd

Cpmcmd

Dpmrep

Answer : C

Question 5

An Unconnected Stored Procedure can run in the following fashions?(Choose all that apply) Choose 3 answers

AFrom an expression

BAs a Post-Session SQL command

CAs a Pre-Session SQL command

DAs the only object In the mapping

Answer : A, B, C

Question 6

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.

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

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

CUse an assignment task to call the ERROR() function

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

Answer : C

Question 7

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

ATrue

BFalse

Answer : A

Informatica PowerCenter Data Integration 9.x:Developer Specialist PR000041 ICP Exam Questions