Reference Data Guide

Back Next

Creating a Reference Table in the Reference Table Editor

Define the table structure and add data to a reference table in the reference table editor.

Click

New

Reference Table

The

New Reference Table

wizard opens.

Select the option to

Use the reference table editor

, and click

Use the

Add New Column

option to add columns to the table.

Configure the properties for each column.

The properties include the column name, data type, precision, and scale.

If the column contains data that a transformation can return in a reference data search, select the Valid option.

Optionally, add a column to include low-level descriptions as metadata in the reference table.

Optionally, enter an audit note for the table.

The audit note appears in the audit trail log.

Click

Enter a name for the reference table, and select a location for the reference table object in the Model repository.

Click

Finish

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.