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

Reference Table Column Properties

Reference Table Column Properties

The column properties contain information about the column metadata.
The following table describes the column properties:
Property
Description
Name
The column name.
Datatype
The data type for the data in each column. You can select one of the following data types:
  • bigint
  • datetime
  • decimal
  • integer
  • string
You cannot create a managed reference table from an Oracle table that uses a number data type if the data type does not specify values for precision and scale.
Precision
The precision for each column. Precision is the maximum number of digits or the maximum number of characters that the column can accommodate.
The precision values you configure depend on the data type.
Scale
The scale for each column. Scale is the maximum number of digits that a column can accommodate to the right of the decimal point. Applies to decimal columns.
The scale values you configure depend on the data type.
Description
An optional description for each column.
Nullable
Indicates if the column can contain null values.
Key
Identifies a primary key column in a table that you import from a database source.
If you update an unmanaged reference table, you cannot add duplicate values to a column that originates from a primary key column in the source database. You can add duplicate values to any column in a managed reference table.

0 COMMENTS

We’d like to hear from you!