IPC Repository Management

Question 1

What is the Informatica PowerCenter Repository?

Accepted Answer

A database that stores all metadata about mapping objects, workflows, and sessions

Answer

The PowerCenter Repository is a relational database that stores all metadata, including mappings, workflows, sessions, and transformation logic used by the Integration Service.

Question 2

Which PowerCenter service manages the repository and provides access to repository metadata for clients?

Accepted Answer

Repository Service

Answer

The Repository Service manages connections to the repository database, handles metadata requests from PowerCenter clients, and enforces repository security.

Question 3

What is the purpose of the Global Repository in a multi-repository PowerCenter environment?

Accepted Answer

To share objects with connected local repositories via shortcuts

Answer

The Global Repository acts as a centralized hub that makes reusable objects available to Local Repositories through shortcuts, enabling code reuse across development teams.

Question 4

In PowerCenter repository management, what is a 'shortcut'?

Accepted Answer

A reference to a shared object in the Global Repository from a Local Repository

Answer

A shortcut is a pointer from a Local Repository to an object in the Global Repository, allowing local developers to use shared objects without duplicating them.

Question 5

Which of the following database systems is NOT supported as a PowerCenter Repository database?

Accepted Answer

MongoDB

Answer

PowerCenter requires a relational database (Oracle, SQL Server, DB2, Sybase) for its repository; MongoDB is a NoSQL document store and is not supported.

IPC - Informatica PowerCenter Certification Practice Test

IPC - Informatica PowerCenter Certification Practice Test

IPC Repository Management