Reference Data Guide

10.5.7
- 10.5.9
- 10.5.8
- 10.5.6
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2

Back Next

Reference Tables

You can create and update reference tables in the Analyst tool and the Developer tool.

Reference tables store metadata in the Model repository. Reference tables can store column data in the reference data warehouse or in another database. When the reference data warehouse stores the column data, the Informatica services identify the table as a managed reference table. When another database stores the column data, the Informatica services identify the table as an unmanaged reference table.

You can use an IBM DB2, Microsoft SQL Server, Microsoft Azure SQL, Oracle, or PostgreSQL database as a reference data warehouse.

Reference Data Warehouse Options on the Content Management Service

The Content Management Service is an application service that manages the connection to the reference data warehouse. You can manage and update the Content Management Service properties in the Administrator tool.

Rules and Guidelines for the Reference Data Warehouse Configuration

Consider the following rules and guidelines when you configure the reference data warehouse:

Verify the database and the schema that the Content Management Service will use for reference data before you create a managed reference table.

You can optionally specify a schema for an IBM DB2, Microsoft SQL Server, Microsoft Azure SQL, or Oracle reference data warehouse.

If you do not specify a reference table schema on the Content Management Service, the service uses the schema that the database connection specifies. If you do not specify a schema on the Content Management Service or on the database connection, the service uses the default database schema.

You must specify the schema on a PostgreSQL reference data warehouse.

Use a JDBC driver to connect to a PostgreSQL reference data warehouse. For information on selecting the JDBC driver for a PostgreSQL reference data warehouse, see the

Installation for PowerCenter and Data Quality Guide

Introduction to Reference Data

Reference Table Structure

Reference Data Warehouse Privileges

Parameters and Reference Tables

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal