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:
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:
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 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:
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:
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:
To create a target definition in the Target Designer:
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:
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.
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.