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.

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.