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
  16. Datatype Reference
  17. Configure the Web Browser

Editing Columns

Editing Columns

You can edit the following information in the Columns tab of a flat file source or target definition:
  • Column Name.
    The names of columns in the flat file source or target.
  • File name columns.
    You can add a file name column to a flat file source or target. For sources, use the CurrentlyProcessedFileName column to return the names of the source files from which rows of data were read. Use this column if you configure the session to read data from a file list. For targets, use the FileName column to dynamically name flat file targets.
  • Datatype.
    The datatype of the column. For flat files, you can choose bigint, datetime, double, int, nstring, number, or string.
  • Precision, Scale, and Format.
    When importing file definitions, you often need to consider the precision, scale, field width, and format of values in each column. You can edit the field width and format by clicking in the Format column. Enter the precision, scale, and format.
  • Not Null.
    Choose whether you want to allow null data in the source or target.
  • Key Type.
    Choose NOT A KEY for flat file source and target definitions.
  • Shift Key.
    You can define the shift state for shift-sensitive fixed-width flat file sources that do not contain shift keys. This attribute appears when you select User Defined Shift State in the Edit Flat File Information dialog box for fixed-width files.
    Choose Shift-In if the column contains single-byte characters. Choose Shift-Out if the column contains multibyte characters.
  • Business Name.
    Optionally, you can add business names to each source or target field.
If the file columns for a source or lookup definition change significantly, you may need to reimport the file.
To edit the columns of flat file source and target definitions:
  1. To edit a source definition, in the Source Analyzer, double-click the title bar of the flat file source definition. To edit a flat file source definition, in the Target Designer, double-click the title bar of the flat file target definition.
  2. Click the Columns tab.
  3. Configure the options of the source or target definition as described above.
  4. If you want to add columns, select a column and click Add.
  5. Enter the name, datatype, and other characteristics of the column.
    Repeat these steps for each column you want to add to the source or target definition.
  6. If you want to move a column, use the Up and Down buttons, or drag it within the scrolling list.

Updated July 02, 2020