Before you create a mapping, you must define targets in the repository. Use the Target Designer to import and design target definitions or to create and maintain target definitions. Target definitions include properties such as column names and data types.
Creating Target Definitions
You can create the following types of target definitions in the Target Designer:
You can create target definitions in the following ways:
The Cubes and Dimensions Wizards follow common principles of data warehouse design to simplify the process of designing related targets.
Maintaining Targets and Target Definitions
In addition to creating target definitions, you can complete the following tasks in the Target Designer:
Target Code Pages
You can create targets with multibyte character sets. Target code pages must be a superset of source code pages when you run a session.
Special Character Handling in Target Definitions
You can import, create, and edit target definitions with table and field names containing special characters, such as the slash (/) character through the Designer. When you import, create, or edit a target definition using the Target Designer, the Designer retains special characters in table and field names when saving the target definition to the repository.
However, when you add a target definition with special characters to a mapping, the Designer either retains or replaces the character. Also, when you generate the target update override in target instance in the Target Designer, the Designer uses quotation marks around table and column names with some special characters. The Designer handles special characters differently for relational and non-relational targets.
The following table describes how the Designer handles special characters in relational targets:
The following table describes how the Designer handles special characters in non-relational targets:
Some databases require special configuration or commands to allow table and field names containing special characters.
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.