PowerCenter All Products
Fixed-Width Flat File Wizard, Step 1 of 3
Flat File Type
File type. Select Fixed Width for a fixed-width file.
Enter a Name for This Source
Name of the source. This is the name of the source 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 it 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_.”
Fixed-Width 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.
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, and Width is the number of bytes to read from source files or to write to target files.
For text columns, Precision is measured in bytes for fixed-width files and in characters for 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 to enter the number of significant digits, but the width must be greater than or equal to the precision.
Only characters 0 to 9 are considered numeric. Columns that contain multibyte character set numbers, such as Japanese, are considered text.