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

Analyst Tool Flat File Properties

Analyst Tool Flat File Properties

When you import a flat file as a reference table, you must configure the properties for each column in the file. The options that you configure determine how the Analyst tool reads the data from the file.
The following table describes the properties you can configure when you import file data for a reference table:
Properties
Description
Delimiters
Character used to separate columns of data. Use the Other field to enter a different delimiter.
Delimiters must be printable characters and must be different from the escape character and the quote character if selected.
You cannot select non-printing multibyte characters as delimiters.
Text Qualifier
Quote character that defines the boundaries of text strings.
Choose No Quote, Single Quote, or Double Quotes.
If you select a quote character, the wizard ignores delimiters within pairs of quotes.
Column Names
Imports column names from the first line. Select this option if column names appear in the first row.
The wizard uses data in the first row in the preview for column names.
Default is not enabled.
Values
Option to start value import from a line. Indicates the row number in the preview at which the wizard starts reading when it imports the file.

0 COMMENTS

We’d like to hear from you!