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. Appendix A: 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 one or more columns to the table. Click the
    New
    option to create a column.
    The following table lists the column properties that you can set:
    Property
    Default Value
    Valid
    Cleared. Select the column that contains the valid values.
    Name
    column
    Data Type
    string
    Precision
    10
    Scale
    0
    Description
    Empty. Optionally enter a description for the column.
    The following table lists properties that you can set for the reference table:
    Property
    Default Value
    Include a column for row-level descriptions
    Cleared
    Description
    Empty
    Default Value
    Empty
    Audit Note
    Empty
  6. Click
    Finish
    .

0 COMMENTS

We’d like to hear from you!