PowerCenter
- PowerCenter 10.4.0
- All Products
Datatype | Fixed-Width Flat Files | Delimited Flat Files |
---|---|---|
Number | Precision is the number of significant digits. Field width is the number of bytes the Integration Service reads from or writes to the file. By default, the field width equals the precision. Use the Format column to define the field width. When you configure the field width, accommodate characters such as thousand separators, decimal separators, and negative signs. For example, “‑123,456” has a field width of 8. | Precision is the number of significant digits. The Integration Service ignores any field width formatting. |
Datetime | You do not enter a precision value. Field width is the number of bytes the Integration Service reads from or writes to the file. The datetime format specified for the column determines the field width. For example, the default datetime format of MM/DD/YYYY HH24:MI:SS has a field width of 19. Use the Format column to define the format and field width. | You do not enter a precision value. The Integration Service ignores any field width formatting. |
String | Precision is the number of bytes the Integration Service reads from or writes to the file. You do not enter a field width for string values. The precision is the total length of the source or target field. If you plan to load multibyte data into a fixed-width file target, you need to configure the precision to accommodate the multibyte data. | Precision is the maximum number of characters the Integration Service reads from or writes to the file. You do not enter a field width. |
03/2002
1.000.000,95