Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  17. Datatype Reference
  18. Configure the Web Browser

Format Column

Format Column

When you override the numeric separators or define the field width, the Designer shows the options you define in the Format column on the Columns tab. For example, you have a numeric column with a precision of five. Click the Format column and define the options in the Column Format Settings dialog box.
The following figure shows the format options the Designer displays in the Format column:
The Columns tab in the Edit Tables dialog box shows the settings for four columns. The PRICE column shows a value for Format.
The Designer displays
N,NNN(F 6.5).NN
in the Format column for the PRICE column. “N,NNN” displays the thousands separator you specified. “F” indicates a fixed field width. This displays “A” when you adjust the field width. “6.5” is the field width and precision in bytes. The first number is the field width, the second is the precision. “.NN” displays the decimal separator you specified.
If you do not define decimal and thousands separators for a particular source or target field, the Integration Service uses the separators you specify in the source or target instance in the Mapping Designer.

Updated June 25, 2018