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 Relational Source Definitions

Editing Relational Source Definitions

You might want to manually edit a source definition to record properties that you cannot import from the source. You can edit a relational source definition to create key columns and key relationships. These relationships can be logical relationships. They do not have to exist in the database.
You can add descriptions or specify links to business documentation for source definitions at any time. Adding descriptions or business documentation links to source definitions is an easy way to document the purpose of a source definition. You can add or modify descriptions to any existing source definition.
To edit a relational source definition:
  1. In the Source Analyzer, double-click the title bar of the source definition.
  2. Edit the following settings:
    Table Settings
    Select Table
    Displays the source definition you are editing. To choose a different open source definition to edit, select it from the list.
    Rename button
    Opens a dialog box to edit the name of the source definition and enter a business name.
    Owner Name
    Table owner in the database.
    Optional description of source table. Character limit is 2,000 bytes/K, where K is the maximum number of bytes for each character in the repository code page. Enter links to business documentation.
    Database Type
    Indicates the source or database type. If necessary, select a new database type.
  3. Click the Columns Tab.
  4. Edit the following settings:
    Column Settings
    Column Name
    The column names in the source. When editing a relational source definition, edit the column name only if the actual source column name changed.
    The datatypes that display in the source definition depend on the source type of the source definition.
    Precision and Scale
    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 sources 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 reads from the source column.
    Not Null
    Choose whether you want to allow null data in the source.
    Key Type
    Select Primary, Foreign, Primary-Foreign, or Not a Key. Applies to relational sources only.
    Business Name
    Optionally, you can add business names to each source column.
  5. Click OK.

Updated July 02, 2020