Table of Contents

Search

  1. Preface
  2. Introduction to Reference Data
  3. Reference Tables in the Analyst Tool
  4. Reference Data in the Developer Tool
  5. Classifier Models
  6. Probabilistic Models
  7. Reference Data and Informatica Data Engineering Integration

Reference Data Guide

Reference Data Guide

Creating a Reference Table Object

Creating a Reference Table Object

Choose this option when you want to create an empty reference table and add values by hand.
  1. Select
    File
    New
    Reference Table
    from the Developer tool menu.
  2. In the new table wizard, select
    Reference Table as Empty
    .
  3. Enter a name for the table.
  4. Select a project to store the table metadata.
    At the Location field, click
    Browse
    . The
    Select Location
    dialog box opens and displays the projects in the repository. Select the project you need.
    Click
    Next
    .
  5. Add two or more columns to the table. Click the
    New
    option to create a column.
    The following table describes the properties for each column:
    Property
    Default Value
    Name
    column
    Data Type
    string
    Precision
    10
    Scale
    0
    Description
    Empty. Optional property.
  6. Select the column that contains the valid values. You can change the order of the columns that you create.
  7. The following table describes optional properties:
    Property
    Default Value
    Include a column for row-level descriptions
    Cleared
    Audit note
    Empty
    Default value
    Empty
    Click
    Finish.
The reference table opens in the Developer tool workspace.

0 COMMENTS

We’d like to hear from you!