Table of Contents

Search

  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. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Designer Guide

Designer Guide

Configuring Tables Options

Configuring Tables Options

You can configure the columns, size, and behavior of table definitions.
To configure table definition options:
  1. Click Tools > Options.
  2. Click the Tables tab.
  3. From the Tables list, select the repository object you want to configure.
    The Columns section lists available display parameters for each repository object. Use the up and down arrows to change the display order of the columns.
  4. You can configure the following options for the selected object type:
    Tables Option
    Tool Availability
    Description
    Columns Default Width
    All tools
    Default width of table columns in bytes.
    Columns Available
    All tools
    Columns that are available to display when the repository object is full-size.
    Columns Selected
    All tools
    Columns that appear in the Designer when the repository object is full-size. To display a column, select it in the Columns Available list and click the double-arrow button to move the column into the Columns Selected list. You can also delete columns and change the order in which they appear.
    Tools
    All tools
    Select the Designer tool you want to configure.
    Import Primary Keys
    Source Analyzer, Target Designer
    Designer imports primary keys for relational source or target definitions.
    Import Foreign Keys
    Source Analyzer, Target Designer
    Designer imports foreign keys for relational source or target definitions.
    Create Source Qualifier When Opening Sources
    Mapping Designer, Mapplet Designer
    Designer creates a Source Qualifier or a Normalizer transformation for each source you add to the mapping. Clear the option to manually create all Source Qualifiers and Normalizers. You might want to create a Source Qualifier manually when you use the Source Qualifier to join relational tables.
    Use Business Names as Column Names for Source Qualifier
    Mapping Designer, Mapplet Designer
    Source Qualifier uses business names as column names.
    General Default Width
    All tools
    Default width of all repository objects.
    General Default Height
    All tools
    Default height of all repository objects.
    Show Tooltips
    All tools
    Shows the column or repository object name when you move the pointer over a column or the title bar of an object. When selected, this option also displays business names when you move the pointer over the icon on the title bar of an object. This option applies to all repository objects.
    Some options on the Tables tab are disabled, depending on the tool that you select to edit. Click Reset All to revert to default setting for this tab.
  5. Repeat steps 3 to 4 for each repository object type you want to configure.

0 COMMENTS

We’d like to hear from you!