Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Appendix A: Naming Conventions
  11. Appendix B: Glossary

Getting Started

Getting Started

Viewing Source Definitions

Viewing Source Definitions

You can view details for each source definition.
  1. Double-click the title bar of the source definition for the EMPLOYEES table to open the EMPLOYEES source definition.
    The
    Edit Tables
    dialog box appears and displays all the properties of this source definition. The
    Table
    tab shows the name of the table, owner name, and the database type. You can add a comment in the Description section. Business name is empty.
  2. Click the
    Columns
    tab.
    The
    Columns
    tab displays the column descriptions for the source table.
    The source definition must match the structure of the source table. Therefore, you must not modify source column definitions after you import them.
    The following image shows the
    Columns
    tab for EMPLOYEES source definition:
     The source columns are: EMPLOYEE_ID, JOB_ID, FIRST_NAME, LAST_NAME, ADDRESS1, ADDRESS2, and CITY.
  3. Click the
    Metadata Extensions
    tab.
    Metadata extensions allow you to extend the metadata stored in the repository by associating information with individual repository objects. For example, you can store contact information, such as name or email address, with the sources you create.
    In this lesson, you create user-defined metadata extensions that define the date you created the source definition and the name of the person who created the source definition.
  4. Click the
    Add Metadata Extension
    button.
  5. Name the row SourceCreationDate and enter today’s date as the value.
  6. Click the
    Add Metadata Extension
    button to add another metadata extension and name it SourceCreator.
  7. Enter your first name as the value in the SourceCreator row.
  8. Click
    Apply
    .
  9. Click
    OK
    to close the dialog box.
  10. Click
    Repository
    Save
    to save the changes to the repository.

0 COMMENTS

We’d like to hear from you!