When you want to create a target definition that closely resembles an existing source definition, you use the source definition or a shortcut to the source definition to create the target definition. Drag the XML source definition into the Target Designer to create an XML target definition or a relational target definition.
Use the following guidelines to create XML target definitions:
When you create an XML target definition from an XML source definition, you create a duplicate of the XML source definition.
A valid XML source definition does not necessarily create a valid XML target definition. To ensure that you create a valid target definition, validate the target definition.
XML target definitions cannot contain pivoted columns.
Use the following guidelines to create relational target definitions:
If you create a relational target definition, the Designer creates the relational target definitions based on the groups in the XML source definition. Each group in the XML source definition becomes a target definition.
The Designer creates the same relationship between the target definitions as between the groups in the source definition.
To create a target definition from an XML source definition:
Drag an XML source definition from the Navigator into the Target Designer workspace.
The XML Export dialog box appears.
Select to create a relational or XML target. Click OK.
The target definition appears in the Target Designer workspace. If you select relational targets, more than one target definition might appear in the workspace, depending on the source.