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.