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

Reimporting a Relational Target Definition

Reimporting a Relational Target Definition

If a target table changes, such as when you change a column datatype, you can edit the definition or you can reimport the target definition. When you reimport the target, you can either replace the existing target definition or rename the new target definition to avoid a naming conflict with the existing target definition.
To reimport a target definition:
  1. In the Target Designer, follow the same steps to import the target definition, and select the target to import.
    The Designer notifies you that a target definition with that name already exists in the repository. If you have multiple tables to import and replace, select Apply To All Tables.
  2. Click Rename, Replace, Skip, or Compare.
  3. If you click Rename, enter the name of the target definition and click OK.
  4. If you have a relational target definition and click Replace, specify whether you want to retain primary key-foreign key information and target descriptions.
    The following table describes the options available in the Table Exists dialog box when reimporting and replacing a relational target definition:
    Option
    Description
    Apply to all Tables
    Select this option to apply rename, replace, or skip all tables in the folder.
    Retain User-Defined PK-FK Relationships
    Select this option to keep the primary key-foreign key relationships in the target definition being replaced. This option is disabled when the target definition is non-relational.
    Retain User-Defined Descriptions
    Select this option to retain the target description and column and port descriptions of the target definition being replaced.


Updated July 02, 2020