PR000005 practice question 14 of 25

The IDQ and PowerCenter repositories all share the same schema.

Full set: 140 questions
Answer options
A:

A. TRUE

B:

B. FALSE

Correct Answer:
[FALSE]
Explanation

The statement is false. Informatica PowerCenter and Informatica Data Quality (IDQ) utilize distinct and architecturally different repositories with separate, incompatible database schemas. The PowerCenter Repository, managed by the PowerCenter Repository Service, is designed specifically to store metadata for ETL objects like mappings, sessions, and workflows. In contrast, IDQ uses the Model Repository, managed by the Model Repository Service (MRS), which has a different schema designed to store metadata for a broader range of platform objects, including profiles, scorecards, reference tables, and data quality rules developed in the Informatica Developer tool. These two repository types cannot share the same database schema.

Why Incorrect

The "True" option is incorrect because the underlying database table structures, metadata models, and managing services for the PowerCenter Repository and the Model Repository are fundamentally different. During the configuration of an Informatica domain, an administrator must create separate database schemas and then create distinct application services (a PowerCenter Repository Service and a Model Repository Service) that point to their respective schemas. Attempting to point both services to the same schema would result in service failure and metadata corruption.

References

1. Informatica 10.4.0 Application Service Guide, Chapter 13: "Model Repository Service", Page 229.

Quote/Paraphrase: This chapter describes the Model Repository Service (MRS) as the service that "manages the Model repository," which stores metadata created by developers and analysts in tools like Informatica Developer and Informatica Analyst. This description establishes it as a distinct entity for platform tools like IDQ, separate from the PowerCenter repository.

2. Informatica 10.4.0 PowerCenter Repository Guide, Chapter 1: "Repository Architecture", Page 10.

Quote/Paraphrase: This section details the specific architecture of the PowerCenter repository, explaining that it "is a relational database that stores the metadata." The guide proceeds to describe tables and concepts (e.g., global vs. local repositories, versioning) that are specific to the PowerCenter ETL environment and differ from the Model Repository's structure.

3. Informatica 10.4.0 Installation and Upgrade Guide, "Part III: After You Install or Upgrade", Chapter 12: "Step 5. Create and Configure Application Services", Pages 208-218.

Quote/Paraphrase: This chapter provides distinct, separate procedures for creating a "PowerCenter Repository Service" and a "Model Repository Service." Each creation process requires the administrator to specify a unique database user and schema that has been prepared for that specific service type. This procedural separation in the official installation guide confirms that they are intended to use different schemas. For instance, the steps on page 212 for the MRS and the steps on page 218 for the PowerCenter Repository Service explicitly require separate database connection details for their respective repositories.

Scroll to Top