1. Which of the following types of Repositories are available in INFORMATICA?

A. National Repositories

B. Local Repositories

C. Global Repositories

D. Both and C

Correct Answer: D

2. The process of upgrading the data quality before loading it to the data warehouse is known as which of the following.

A. Data transformation

B. Data scrubbing

C. Data cleansing

D. Both B and C

Correct Answer: D

3. Which of the following is an active transformation?

A. Stored procedure  

B. Expression

C. Normalizer

D. Router

Correct Answer: C

4. Which among the following is not a reusable transformation?

A. External procedure

B. Filter

C. Source qualifier

D. Aggregator

Correct Answer: C

5. What are the results when you run the maximum number of sessions and complete database log files?

A. Session fails

B. Session log out

C. Session expires

D. Error occurs

Correct Answer: C

6. Name the Transformations which is used to combine data from different sources?

A. Rank transformation

B. Union Transformation

C. Normalizer Transformation

D. Expression transformation

Correct Answer: B

7. Name the servers governs the implementation of various processes based on elements of the server's database repository?

A. Powerhouse server

B. Repository server

C. Domain server

D. Temp server

Correct Answer: A

8. Which of the following is the reusable component in Informatica PowerCeter?

A. Workflow

B. Mapping

C. Mapplet

D. Session

Correct Answer: C

9. Name the following session properties which enables when a mapping uses an update strategy?

A. DD_INSERT

B. DD_UPDATE

C. DD_REJECT

D. Data Driven

Correct Answer: D

10. Name the transformation which is used to convert the rows in to columns?

A. Source Qualifier

B. Normalizer Transformation

C. Filter Transformation

D. Router Transformation

E. Rank Transformation

Correct Answer: B