IPC Repository Management 1 — Questions and Answers
Question 1: What is the Informatica PowerCenter Repository?
- A flat file system that stores transformation logic
- A database that stores all metadata about mapping objects, workflows, and sessions (Correct answer)
- An in-memory cache that stores runtime execution data
- A web service that manages user authentication
Correct 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.
Question 2: Which PowerCenter service manages the repository and provides access to repository metadata for clients?
- Integration Service
- Web Services Hub
- Repository Service (Correct answer)
- Reporting Service
Correct answer: Repository Service
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?
- To store audit logs for all PowerCenter operations
- To manage user authentication across all repositories
- To serve as the primary execution engine for all workflows
- To share objects with connected local repositories via shortcuts (Correct answer)
Correct 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.
Question 4: In PowerCenter repository management, what is a 'shortcut'?
- A reference to a shared object in the Global Repository from a Local Repository (Correct answer)
- A keyboard shortcut for accessing repository objects
- A quick-connect alias for database connection strings
- An abbreviated version of a mapping name
Correct 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.
Question 5: Which of the following database systems is NOT supported as a PowerCenter Repository database?
- Oracle
- Microsoft SQL Server
- MongoDB (Correct answer)
- IBM DB2
Correct 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.
Question 6: What occurs when the Repository Service is placed into exclusive mode?
- Multiple users can access the repository simultaneously with elevated privileges
- The repository replicates data to a standby server in real time
- Only administrators can connect, blocking all regular user sessions for maintenance (Correct answer)
- The repository automatically backs up all objects to the file system
Correct 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.
Question 7: Which repository type in a PowerCenter domain acts as the central hub that shares reusable objects with other repositories?
- Local Repository
- Standalone Repository
- Development Repository
- Global Repository (Correct answer)
Correct 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.
IPC Repository Management 1
What is the Informatica PowerCenter Repository?