Creating a Target Definition from a Transformation - Informatica

To create a relational target definition that closely matches a transformation in the repository, you can create the target from the transformation. Drag a transformation from the Navigator to the Target Designer, or create a target from a transformation in the Mapping Designer workspace.

Create target definitions from the following types of transformations:

  • Single-group transformations. Create a single target definition from a transformation with one output group.
  • Multiple-group transformations. Create multiple target definitions from a transformation with multiple output groups.
  • Normalizer transformations. Create a target definition from a source qualifier or pipeline Normalizer transformation.
  • Mapplets. Create one or more target definitions from a mapplet instance in a mapping.

When you create a target definition from a transformation, the target database type is the same as the repository database by default. After you create the target definition in the repository, you can edit it. For example, you might want to change the target type.

If you need to create a target definition that contains columns from more than one transformation, you can copy the ports from each transformation to a transformation such as an Expression or Joiner. You can create the target definition from that transformation.

When you create a relational target definition, you must generate and execute the SQL to create the table in the target database.

Creating a Target from a Transformation with One Output Group

When you create a target from a transformation with one output group, the Designer creates one target. All the output ports become input ports in the target. The name of the target is the same as the transformation name.

Creating a Target from a Transformation with Multiple Output Groups

When you create targets from a transformation with more than one output group, the Designer creates one target for each output group in the transformation. When the< transformation is a plug-in or Custom transformation, the Designer retains the primary key -foreign key relationships between the groups in the target definitions.

The following figure shows a transformation with multiple output groups:

Creating a Normalized Target from a COBOL Source

The Employees XML Parser transformation has five output groups, from X_emp_EMPLOYEES to X_emp_PHONE. Each output group represents different types of employee information. DataInput is the input group.

When you create a target from this transformation, the Designer creates a separate target for each output group.

Each target has the corresponding group name from the transformation group, as shown in the following figure:

Creating a Target from a Transformation with Multiple Output Groups

Creating a Target from a Normalizer Transformation

You can create a target from a source qualifier or pipeline Normalizer transformation. When you create a target from a Normalizer transformation, the Designer creates one target and includes all the columns from the Normalizer. It does not create separate targets to represent the record hierarchies or multiple-occurring fields in the Normalizer transformation.

The following figure shows a Normalizer transformation in a mapping with a COBOL source definition:

Creating a Target from a Normalizer Transformation

The Normalizer transformation, Norm_Company_Sales, represents the hierarchical data structure of the Company_Sales COBOL source definition. When you create a target from the Norm_Company_Sales transformation, the Designer flattens the hierarchies in the transformation into one target. The target includes the generated keys from the Normalizer transformation and the generated column ID (GCID) for the multiple-occurring records, DETAIL_DATA and SUPPLIER_INFO.

Creating a Target from a Mapplet

You can create a target from a mapplet that is under a mapping Transformation Instances node. When you drag the mapplet instance to the Target Designer, the Designer creates a target for each output group in the mapplet.

Note:You cannot create a target when you drag a transformation instance from a mapplet to the Target Designer.

Transformation and Target Datatypes

The Designer creates the target datatypes based on the best match between the transformation datatypes and the datatypes for the repository database.

The following table describes the transformation datatypes and the corresponding datatypes for each database:

Transformation and Target Datatypes

Steps to Create a Target

You can create a target by dragging one or more transformations from the Navigator to the Target Designer or you can create a target from a transformation instance in the Mapping Designer.

Steps to Create a Target in the Target Designer

You can create one or more targets in the Target Designer by selecting transformations in the Navigator and dragging them to the Target Designer workspace.

When you create a target from a transformation in a different folder, the Designer copies the transformation to the target folder and creates the target from the transformation. When you create a target from a transformation in a shared folder, the Designer creates a shortcut to the transformation in the target folder before it creates the transformation.

The following table describes the objects you can use to create a target in the Target Designer:

Transformation and Target Datatypes

To create a target definition in the Target Designer:

  1. Open the Target Designer.
  2. Drag a transformation from the Transformations node or the Transformation Instances node in the Navigator to the workspace.

The target definition appears.

The Designer adds the new target to the Navigator and the Target Designer workspace. When you use version control in the repository, the new target is checked out by default.

If the new target name conflicts with an existing target name, the Designer prompts you to rename the new target or replace the existing target definition.

Steps to Create a Target in the Mapping Designer

You can create a target from a transformation instance in the Mapping Designer. When you create a target in the Mapping Designer, you create a target instance in the mapping. The Target Designer displays the target definition.

To create a target definition in the Mapping Designer:

  1. Open a mapping in the Mapping Designer.
  2. Right-click a transformation instance in the mapping.
  3. Click Create and Add Target.

If the repository contains a target definition with the same name, you must create the target in the Target Designer instead of the Mapping Designer.

If there are no name conflicts, the Designer adds the new target to the Navigator and to the Mapping Designer workspace. You can link the transformation ports to the target.


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

Informatica Topics