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:
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 following figure shows a sample COBOL source definition with five OCCURS statements:
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:
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.
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.