Informatica PR000041 ICP Exam Questions Instant Access

Question 1

Subqueries can be used in the SQL override for uncached lookup transformations.

ATrue

BFalse

Answer : B

Question 2

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

ATrue

BFalse

Answer : A

Question 3

A Router transformation has the following group filter conditions:

-Group A: InputValue = 2 -Group B: InputValue > 1 -Default group

The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

AIf InputValue = 2, the output will be routed to Group A only

BIf InputValue = 2, the output will be routed to both groups A and B

CIf InputValue = 2, the router will fail, since rows cannot be routed to multiple groups

DAny positive number values other than 1 or 2 will be routed to the Default group

Answer : B

Question 4

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

ASTATE

B'CA'

CNULL

DValue of the PREVI0US_STATE port is based upon its declared default value

Answer : B

Question 5

In which of the following selections are all of the transformations active?

AExpression, Router, Joiner

BUpdate Strategy, Expression, Aggregator

CStored Procedure, Joiner, Router

DRouter, Update Strategy, Joiner

Answer : D

Question 6

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 7

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

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

BThe transformation's name or the tracing level

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

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

Answer : B

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