Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Analyst
  3. Library Workspace
  4. Connections Workspace
  5. Job Status Workspace
  6. Projects Workspace
  7. Model Repository
  8. Data Objects
  9. Search
  10. Appendix A: Configure the Web Browser

Analyst Tool Guide

Analyst Tool Guide

Flat File Options

Flat File Options

When you import a flat file data object, you can configure the flat file options for each column in
Add Flat File
wizard. The options that you configure determine how the wizard reads the data from the source flat file.
You can configure the following flat file options in the
Add Flat File
wizard:
Code Page
Code page of the data in the flat file object. Select a code page that matches the code page of the data in the flat file object.
Delimiters
Character used to separate columns of data. Use the Other field to enter a different delimiter. Printable characters must be different from the escape character and the quote character if selected. You can input the following non-printing multibyte characters:
\1
,
\01
, or
\001
.
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
Option to import 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.
If the first row contains numeric characters, the wizard uses COLUMNx as the default column name. If the first row contains special characters, the wizard converts the special characters to underscore and uses the valid characters in the column name. The wizard skips the following special characters in a column name: " . + - = ~ ` ! % ^ & * ( ) [ ] { } ' \ " ; : ? , < > \ \ | \t \r \n. 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!