Designer Guide

Back Next

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:

In the Designer, connect to the repository containing the source definition you want to update.

Open the Source Analyzer and import the source definition again.

The Designer prompts you to rename or replace the existing source tables.

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.

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.

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.