1. What are below mentioned variables is not a transaction control variable?

A. TC COMMIT AFTER

B. TC_CONTINUE_TRANSCTION

C. TC_ROLLBACK_BEFORE

D. TC_COMMIT_TRANSACTION

Correct Answer: D

2. Which of the following informatica PowerCenter component cannot be made highly available?

A. Gateway Node

B. PowerCenter Integration Service

C. PowerCenter Reporting Service

D. PowerCenter Repository Service

Correct Answer: C

3. By What process one joiner transformation can join data?

A. By using 2 pipeline inputs

B. By using N pipeline inputs

C. By using N-2 pipeline inputs

D. All the above are correct.

Correct Answer: A

4. Which of the following combination of Transaction Control Transformation and target type causes an invalid mapping?

A. XML target

B. Relational target

C. Dynamic MQ Series target

D. MS Target

Correct Answer: D

5. Which of the below mentioned transformations can be unconnected with a valid mapping in informatica PowerCenter?

A. Transaction control, java, lookup

B. Java, lookup, transaction control

C. Lookup, external procedure, stored procedure.

D. Stored procedure, java, Lookup.

Correct Answer: C

6. What command line tool do you use to import workflows into the repository in PowerCenter?

A. infacmd

B. Infasetup

C. pmrep

D. pmcmd

Correct Answer: C

7. Choose the correct one which belongs to Active Transformation Group?

A. Router Transformation, Update Strategy, Joiner

B. Stored Procedure, Joiner, Router Transformation

C. Expression, Router Transformation, Joiner

D. Update Strategy, Expression Transformation, Aggregator Transformation

Correct Answer: A

8. Which of the below mentioned option is the default value for transaction control transformation variables?

A. TC_COMMIT_BEFORE

B. TC_ROLLBACK_BEFORE

C. TC_COMMIT_AFTER

D. TC_CONTINUE_TRANSACTION

Correct Answer: D

9. When you create mapping using aggregator transformation. The Aggregator transform receives sorted input from a sorted transformation in mapping. Then what should be default partition type for aggregator Transformation?

A. Based on the transformation scope

B. Hash auto-keys

C. Not valid partition points

D. Pass-through

Correct Answer: B

10. Metadata stored in which of the following in Informatica PowerCenter?

A. Flat_file

B. Database

C. Open Database Connectivity

D. Repository

Correct Answer: B