Creating a Target Definition from a Source Definition - Informatica

When you want to create a target definition that closely matches a source definition, you can use the source definition to create the target definition. You can also use a shortcut to a source definition to create the target definition. You can drag the following source definitions into the Target Designer to create target definitions:

  • Relational sources
  • Flat file sources
  • COBOL sources
  • XML sources

After you create the matching target definition, you can add or edit target properties and change the target type. When you create a relational target definition, you can generate the target table in the target database.

Creating a Target Definition from a Relational Source

When you drag a relational source definition into the Target Designer workspace, the Designer creates a relational target definition that matches the source definition.

You can edit the definition to change information, such as the description, columns, data types, and target type.

Creating a Target Definition from a Flat File Source

When you drag a flat file source definition into the Target Designer workspace, the Target
Designer creates a flat file target definition by default that matches the source definition.

When you create a flat file target definition from a flat file source definition, the Designer uses the flat file source definition code page.

You can edit the definition to change information, such as the description, columns, datatypes, and target type.

Creating a Normalized Target from a COBOL Source

To create a target based on normalized COBOL sources, you first need to analyze the COBOL structure using the Source Analyzer.

When you drag a normalized COBOL source definition into the Target Designer workspace, the Target Designer creates relational target definitions based on the following rules:

  • The number of tables that appears is one more than the number of OCCURS statements in the COBOL file.
  • The target table name defaults to the record name.
  • The generated key name for each table is GK_target_table_name.
  • The number of generated key names is the number of OCCURS statements minus the number of primary keys.

The following figure shows a sample COBOL source definition with five OCCURS statements:

Creating a Normalized Target from a COBOL Source

When you drag the source into the Target Designer workspace, the Designer creates six target definitions.

Steps to Create a Target Definition from a Source Definition

Use the following procedure to create a target definition from a source definition.

To create a target definition based on a source definition:

  1. With the Target Designer tool active, drag the source definition you want to use into the workspace. For XML sources, select the option to create relational targets or XML targets and click OK.
  2. The target definition appears.
  3. To edit the target definition, double-click the title bar.
  4. Enter a target name and select the target type. Add or edit columns or target properties, and then click OK.

You can now use the target definition in a mapping. You can also create a target tables in the target database based on relational target definitions.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Informatica Topics