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. POWERCENTERHELP
  17. Datatype Reference
  18. Configure the Web Browser

Reimporting a Source Definition

Reimporting a Source Definition

Complete the following steps to reimport a source definition. You can retain the following information in the source definition being replaced:
  • Primary key-foreign key relationships
  • Source definition description
  • Column or port description
To reimport a relational source definition:
  1. In the Designer, connect to the repository containing the source definition you want to update.
  2. Open the Source Analyzer and import the source definition again.
  3. The Designer prompts you to rename or replace the existing source tables.
  4. To view the differences between the table you are importing and the existing table, click Compare.
    A dialog box displays the attributes in each source side-by-side.
  5. Specify whether you want to retain primary key-foreign key information or source descriptions in the existing source definition.
    The following table describes the options in the Table Exists dialog box:
    Option
    Description
    Apply to all Tables
    Apply rename, replace, or skip all tables in the folder.
    Retain User-Defined Pk-Fk Relationships
    Keep the primary key-foreign key relationships in the source definition being replaced.
    Retain User-Defined Descriptions
    Retain the source description and column and port descriptions of the source definition being replaced.
  6. Click Replace, Rename, or Skip:
    Option
    Description
    Replace
    Replace the source definition with a new one.
    Rename
    Enter a unique name for the new source definition.
    Skip
    Do not import the new source definition.
  7. If you click Rename, enter the name of the source definition and click OK.


Updated June 25, 2018