Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Datatype Reference
  17. Configure the Web Browser

Creating Target Definitions

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
    , 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.

Updated July 02, 2020