Reference Data Guide

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

Back Next

Creating a Reference Table from a Relational Source

To create the reference table, connect to a database and select the table that contains the reference data.

Select

File

New

Reference Table

from the Developer tool menu.

In the table creation wizard, select

Reference Table from a Relational Source

Click

Select a database connection.

At the Connection field, click

Browse

. The

Choose Connection

dialog box opens and displays the available database connections.

Click

when you select a connection.

Select a database resource.

At the Resource field, click

Browse

. The

Select a Resource

dialog box opens and displays the resources on the database connection. Explore the database and select a database table, synonym, or view.

You can optionally preview the entity information on the resource.

Enter a name for the table.

Select a location for the reference table object.

At the Location field, click

Browse

. The

Select Location

dialog box opens and displays the projects in the repository.

Select a location and click

To create a reference table that does not store data in the reference data warehouse, select

Unmanaged table

To enable users to edit an unmanaged reference table, select the

Editable

option.

Click

Select the column that contains the valid values.

The following table describes optional properties that you can specify:

Property	Default Value
Include a column for row-level descriptions	Cleared
Description	Cleared
Default value	Empty
Audit note	Empty
Maximum rows to preview	500

Click

Finish.

Create a Reference Table from a Relational Source

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

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

Rename Saved Search

Table of Contents

Reference Data Guide

Reference Data Guide

Creating a Reference Table from a Relational Source

Creating a Reference Table from a Relational Source