PR000005 practice question 6 of 25

Which of the following is not true when it comes to creating and updating Reference Tables?

Full set: 140 questions
Answer options
A: Reference Tables can be updated from a Value Frequency list in the Developer
B: All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst
C: Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories Correct answer
D: Reference Tables can be imported and exported using the Developer Tool
Correct Answer:
C. Reference Tables maintained in the Analyst and Developer tools are stored in separate repositories
Explanation

The statement that is not true is C. The Informatica Analyst and Developer tools are clients that connect to the same, shared Model Repository Service (MRS). The MRS acts as a central repository for storing metadata for all projects and objects, including Reference Tables. An object, such as a Reference Table, created or maintained in the Analyst tool is stored in the MRS and is accessible from the Developer tool, and vice versa (subject to permissions). They do not use separate repositories.

Why Incorrect

A. Reference Tables can be updated from a Value Frequency list in the Developer This is a true statement. The Developer tool allows users to create or append data to a reference table directly from the value frequency results of a column profile, which is a common method for populating reference data.
B. All except Un-Managed Reference Tables can be updated through the Reference Table Manager in the Analyst This is a true statement. The Analyst tool's Reference Table Manager is designed to create, edit, and manage the content of managed reference tables (stored in the MRS). It can only view the content of unmanaged reference tables (external database tables).
D. Reference Tables can be imported and exported using the Developer Tool This is a true statement. Reference tables are standard objects within the Model Repository and can be imported and exported using the Developer tool's object management features or infacmd command-line utilities, facilitating migration between environments. ---

References

1. Informatica 10.5 Application Service Guide, "Model Repository Service," Page 11.

This guide states, "The Model Repository Service is a relational database that stores the metadata for projects and objects that you create in the Developer tool and the Analyst tool." This directly refutes option C by confirming both tools use a single, shared repository.

2. Informatica 10.5 Data Quality Analyst Guide, "Reference Tables," Page 10.

This document clarifies, "You can use the Reference Table Manager to create, view, edit, and delete managed reference tables... You can view the data in an unmanaged reference table, but you cannot edit the data or delete the table." This confirms that option B is a true statement.

3. Informatica 10.5 Data Quality Developer Tool Guide, "Create a Reference Table from Profile Results," Page 513.

This section provides instructions on how to populate a reference table from profiling results: "You can create a reference table from the value frequency statistics in a column profile. You can also add the value frequency statistics to an existing reference table." This confirms that option A is a true statement.

4. Informatica 10.5 Developer Tool Guide, "Object Import and Export," Page 50.

This chapter details the process for moving assets between repositories. It states, "You can import and export repository objects between repositories in the same domain or in different domains." Reference tables are repository objects and are included in this functionality, confirming option D is a true statement.

Scroll to Top