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
Which PowerCenter Repository mechanism ensures that only one developer can modify a versioned object at a time?
Answer: Object check-out and locking
When versioning is enabled, developers must check out an object before editing it, which places a lock that prevents other users from modifying the same object simultaneously.
What does enabling high availability for the Repository Service provide in a PowerCenter domain?
Answer: Failover capability so that if the active Repository Service instance fails, another takes over
Repository Service high availability configures redundant service instances so that a failure of the active instance triggers automatic failover to a standby, minimizing downtime.
In PowerCenter, what is a 'Deployment Group' used for?
Answer: Grouping related repository objects together for controlled migration between environments
A Deployment Group is a named collection of repository objects that can be exported from one repository and imported into another, supporting structured environment promotions.
Which of the following repository object types can store reusable transformation logic that is shared across multiple mappings?
Answer: Both Reusable Transformations and Mapplets
Both Reusable Transformations (single transformations reused across mappings) and Mapplets (mini-pipelines of multiple transformations) enable logic reuse across multiple mappings.
When an object in the Global Repository is updated, what happens to Local Repository shortcuts that reference it?
Answer: Shortcuts automatically reflect the latest changes from the Global Repository
Shortcuts are live references rather than copies, so when the source object in the Global Repository changes, all Local Repository shortcuts that point to it automatically inherit the update.
Which of the following operations typically requires the Repository Service to be in exclusive mode?
Answer: Upgrading the repository schema to a new PowerCenter version
Upgrading the repository schema modifies the underlying database structure and requires exclusive mode to prevent data corruption from concurrent user activity during the upgrade.
What is the primary function of the 'pmrep connect' command?
Answer: To establish a session connection to a repository before executing subsequent pmrep commands
pmrep connect authenticates and establishes a connection to a specified repository, which must be done before any other pmrep commands can be executed in that session.