Working With Targets overview - Informatica

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:

  • Relational. Create a relational target for a particular database platform. Create a
    relational target definition when you want to use an external loader to the target
    database.
  • Flat file. Create fixed-width and delimited flat file target definitions.
  • XML file. Create an XML target definition to output data to an XML file.

You can create target definitions in the following ways:

  • Import the definition for an existing target. Import the target definition from a relational target or a flat file.
  • The Target Designer uses a Flat File Wizard to import flat files.
  • Create a target definition based on a source definition. Drag a source definition into the Target Designer to make a target definition.
  • Create a target definition based on a transformation or mapplet. Drag a transformation into the Target Designer to make a target definition.
  • Manually create a target definition. Create a target definition in the Target Designer.
  • Design several related target definitions. Create several related target definitions at the same time. You can create the overall relationship, called a schema, and the target definitions, through wizards in the Designer.
  • 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:

  • Reimport target definitions. When the target structure changes significantly, you can reimport the target definition to make sure it is correct.
  • Edit target definitions. Edit target definitions to add comments or key relationships, or update them to reflect changed target definitions.
  • Create relational tables in the target database. If the target tables do not exist in the target database, you can generate and execute the necessary SQL code to create the target table that matches the target definition.
  • Preview relational and flat file target data. You can preview the data of relational and flat file target definitions in the Designer.
  • Compare target definitions. You can compare two target definitions to identify differences between them.

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:

Special Character Handling in Target Definitions

The following table describes how the Designer handles special characters in non-relational targets:

Special Character Handling in Target Definitions

Some databases require special configuration or commands to allow table and field names containing special characters.


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

Informatica Topics