PowerCenter All Products
Delimited Flat File Wizard, Step 1 of 3
Flat File Type
File type. Select Delimited for a delimited file.
Enter a Name for This Source
Name of the source. This is the name of the source definition in the repository. You can use the file name or any other logical name.
Start Import At Row
Indicates the row number at which the Flat File Wizard starts reading when Flat File Wizard imports the file. For example, if you specify to start at row 2, the Flat File Wizard skips 1 row before reading.
Import Field Names From First Line
If selected, the Designer uses data in the first row for column names. Select this option if column names appear in the first row. Invalid field names are preceded by “FIELD_”.
Delimited Flat File Wizard, Step 2 of 3
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 unprintable multibyte characters as delimiters.
Treat Consecutive Delimiters as One
If selected, the Flat File Wizard reads one or more consecutive column delimiters as one. Otherwise, the Flat File Wizard reads two consecutive delimiters as a null value.
Treat Multiple Delimiters as AND
If selected, the Flat File Wizard reads a specified set of delimiters as one.
Character immediately preceding a column delimiter character embedded in an unquoted string, or immediately preceding the quote character in a quoted string. When you specify an escape character, the Integration Service reads the delimiter character as a regular character. This is called
escapingthe delimiter or quote character.
Remove Escape Character From Data
This option is selected by default. Clear this option to include the escape character in the output string.
Use Default Text Length
If selected, the Flat File Wizard uses the entered default text length for all string datatypes.
Quote character that defines the boundaries of text strings. Choose No Quote, Single Quote, or Double Quotes. If you select a quote character, the Flat File Wizard ignores delimiters within pairs of quotes.
Delimited Flat File Wizard, Step 3 of 3
Port name that you want to appear for each column. If you select Import Field Names from First Line, the wizard reads the column names provided in the file instead.
Column datatype. Select Text, Numeric, or Datetime, and then enter the appropriate Length/Precision, Scale, and Width.
For numeric columns, Precision is the number of significant digits. The Flat File Wizard ignores the width for numeric columns in delimited files.
For Text columns, Precision is the maximum number of characters contained in the source field or the target field. The Flat File Wizard ignores the precision when reading text columns in or writing text columns to delimited files.
By default, the Flat File Wizard enters the same value for both Precision and Width. You can change the value of the precision or width, but the Flat File Wizard only lets you define the precision to be greater than or equal to the width.
Only characters 0 to 9 are considered numeric. Columns that contain multibyte character set numbers, such as Japanese, are considered text.