Data Quality Integration for PowerCenter Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1

Back Next

Reference Table Data Requirements

Before you run a mapping that reads reference tables in PowerCenter, copy the column data for the tables to the PowerCenter services machine.

When you export the mapping from the Model repository, the export operation writes the reference table column data to one or more files. The export operation adds the files to a compressed file at a location that you specify. Extract the compressed file and find the column data files. The file names end in

.dic

. Copy the files to the PowerCenter services machine.

The reference data file locations in the PowerCenter directory structure must correspond to the reference table locations in the Model repository.

Use the following directory format to determine the correct locations for the reference table data files:

<PowerCenter_Root_Directory>\services\<Model_Repository_Project_Name>\<Model_Repository_Project_Folder_Name>

Rules and Guidelines for Reference Table Data Export

Consider the following rules and guidelines when you export a mapping that reads reference table data:

To export the mapping from the Model repository, choose the

Informatica

PowerCenter

option in the export wizard. When you choose the

PowerCenter

option, the export operation writes both managed reference table data and unmanaged reference table data to the file system.

The export operation specifies the first column in each reference table as the valid column.

PowerCenter reads reference data files in UTF-8 format.

Using an Environment Variable to Define the Reference Data File Location

You can define an INFA_CONTENT environment variable on the PowerCenter Integration Service machine to set the path that the Integration Service uses to read reference data files.

Use this environment variable if you cannot install the files in the required location on the PowerCenter Integration Service machine. Install the files in a location that the PowerCenter Integration Service can read, and create the INFA_CONTENT environment variable with the installed path.

Rename Saved Search

Table of Contents

Data Quality Integration for PowerCenter Guide

Data Quality Integration for PowerCenter Guide

Reference Table Data Requirements

Reference Table Data Requirements

Rules and Guidelines for Reference Table Data Export

Using an Environment Variable to Define the Reference Data File Location