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

Editing Table Options

Editing Table Options

You can edit the following options on the Table tab of a flat file source or target definition:
  • Business name.
    Add a more descriptive name to the source or target definition.
  • Description.
    Add a comment or link to business documentation. These display in Repository Manager for the source or target definition. Adding comments or business documentation links to a source or target is an easy way to document its purpose. You can add or modify comments to any existing source or target.
    You can enter up to (2,000 bytes)/K characters in the description, where K is the maximum number of bytes a character contains in the selected repository code page. For example, if the repository code page is a Japanese code page where K=2, each description and comment field can contain up to 1,000 characters.
  • Keywords.
    Track flat file targets with key words. As development and maintenance work continues, the number of targets increases. While all of these targets may appear in the same folder, they may all serve different purposes. Keywords can help you find related targets. Keywords can include developer names, mappings, or the associated schema.
    Use keywords to perform searches in the Repository Manager.
  • Database type.
    Define the source or target type. Choose Flat File for flat file sources and targets.
  • Flat file information.
    When the database type is flat file, define the flat file properties by clicking the Advanced button.
To add options to a flat file source or target definition:
  1. To add options to a source definition, in the Source Analyzer, double-click the title bar of the source definition. To add options to a target definition, in the Target Designer, double-click the title bar of the target definition.
    The Edit Tables dialog box appears.
  2. Click the Rename button to edit the source or target name and the business name.
  3. Choose Flat File in the Database Type field.
  4. Click the Advanced button to edit the flat file properties.
    A different dialog box appears for fixed-width and delimited files.
  5. To add a description, type a description in the Description field.
  6. To add keywords for target definitions, click Edit Keywords.
    The Edit Keywords dialog box appears. Use the buttons to create and move keywords.

Updated June 25, 2018