Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: Configuring Hub Console Tools
  4. Part 3: Building the Data Model
  5. Part 4: Configuring the Data Flow
  6. Part 5: Executing Informatica MDM Hub Processes
  7. Part 6: Configuring Application Access
  8. Appendix A: MDM Hub Properties
  9. Appendix B: Viewing Configuration Details
  10. Appendix C: Row-level Locking
  11. Appendix D: MDM Hub Logging
  12. Appendix E: Table Partitioning
  13. Appendix F: Collecting MDM Environment Information with the Product Usage Toolkit
  14. Appendix G: Glossary

Navigating to the Column Editor

Navigating to the Column Editor

To configure columns for base objects and landing tables:
  1. Start the Schema Manager.
  2. Acquire a write lock.
  3. Expand the schema tree for the object to which you want to add columns.
  4. Select
    Columns
    .
    The Schema Manager displays column definitions in the Properties pane.
    The Column Editor displays a “lock” icon next to system columns if you select the
    Show system columns
    check box.

Command Buttons in the Column Editor

The Properties pane in the Column Editor contains the following command buttons: 
Button
Name
Description
Add Column
Adds new columns.
Remove Column
Removes existing columns.
Edit Column Description
Allows editing the description of the selected column.
Move Up
Moves the selected column up in the display order.
Move Down
Moves the selected column down in the display order.
Import Schema
Allows adding new columns by importing column definitions from another table.
Expand table columns view
Expands the table columns view.
Restore table columns view
Restores the table columns view.
Save
Saves changes to the column definitions.

Showing or Hiding System Columns

You can toggle the Show System Columns check box to show or hide system columns.

Expanding the Table Columns View

You can expand the properties pane to display all the column properties in a single pane. By default, the Schema Manager displays column definitions in a contracted view.
To show the expanded table columns view:
  • Click the
    Expand table columns view
    button.
    The Schema Manager displays the expanded table columns view.
To show the default table columns view:
  • Click the
    Restore table columns view
    button.
    The Schema Manager displays the default table columns view.

0 COMMENTS

We’d like to hear from you!