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 the target definition:
  • Column name.
    The column names in the target. When editing a relational target definition, edit the column name if you are manually creating the relational target definition or if the actual target column name changed.
  • Datatype.
    The datatypes that display in the target definition depend on the target type of the target definition.
  • Precision and scale.
    When designing or importing relational targets, consider the precision and scale of values in each column.
    is the maximum number of significant digits for numeric datatypes, or the maximum number of characters for string datatypes. Precision includes scale.
    is the maximum number of digits after the decimal point for numeric values. Therefore, the value 11.47 has a precision of 4 and a scale of 2. The string
    has a precision (or length) of 11.
    All datatypes for relational targets have a maximum precision. For example, the Integer datatype has a maximum precision of 10 digits. Some numeric datatypes have a similar limit on the scale or do not allow you to set the scale beyond 0. Integers, for example, have a scale of 0, since by definition they never include decimal values.
    You can change the precision and scale for some datatypes to values that differ from the values defined in the database. However, changing the precision or scale can cause numeric overflow on numeric columns, truncation on character columns, or insertion of zeroes on datetime columns when the Integration Service writes to the target column.
  • Not null.
    Choose whether you want to allow null data in the target.
  • Key type.
    Select Primary, Foreign, Primary-Foreign, or Not a Key. Applies to relational targets only.
  • Business name.
    Optionally, you can add business names to each target column.
To edit the columns of a relational target definition:
  1. In the Target Designer, double-click the title bar of a target definition.
  2. Select the Columns tab.
  3. Configure the options of the target definition as described above.
  4. If you are creating a target definition and 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 table.
  6. If you want to move a column, use the Up and Down buttons, or drag it within the scrolling list.
  7. Click OK.

Updated July 02, 2020