Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Object Import and Export
  12. Data Type Reference
  13. Keyboard Shortcuts
  14. Connection Properties

Developer Tool Guide

Developer Tool Guide

Creating Keys in a Relational Data Object

Creating Keys in a Relational Data Object

Create key columns to identify each row in a relational data object. You can create one primary key in each relational data object.
  1. Open the relational data object.
  2. Select the
    Keys
    view.
    The following figure shows the
    Keys
    view for a sample relational data object that is open in the editor:
    The Keys view shows a key defined for the relational data object. The view also shows the name, description, and available and selected columns for the key.
  3. Click
    Add
    .
    The
    New Key
    dialog box appears.
  4. Enter a key name.
  5. If the key is a primary key, select
    Primary Key
    .
  6. Select the key columns.
  7. Click
    OK
    .
  8. Save the relational data object.

0 COMMENTS

We’d like to hear from you!