Practice Test GeeksIPC - Informatica PowerCenter Certification Practice Test
← All IPC Flashcard Decks

Repository Management Flashcards

7 cards from real IPC practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Repository Management flashcards as text

  1. What is the Informatica PowerCenter Repository?

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

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

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

    Answer: Repository Service

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

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

    Answer: To share objects with connected local repositories via shortcuts

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

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

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

    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.

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

    Answer: MongoDB

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

  6. What occurs when the Repository Service is placed into exclusive mode?

    Answer: Only administrators can connect, blocking all regular user sessions for maintenance

    Exclusive mode restricts repository access to a single administrative connection, typically used for maintenance tasks such as upgrades or cleanup operations.

  7. Which repository type in a PowerCenter domain acts as the central hub that shares reusable objects with other repositories?

    Answer: Global Repository

    The Global Repository is designated as the central sharing hub in a connected repository group, while Local Repositories consume its shared objects via shortcuts.