To create a relational target definition that closely matches a transformation in the repository, you can create the target from the transformation. Drag a transformation from the Navigator to the Target Designer, or create a target from a transformation in the Mapping Designer workspace.
Create target definitions from the following types of transformations:
Create a single target definition from a transformation with one output group.
Create multiple target definitions from a transformation with multiple output groups.
Create a target definition from a source qualifier or pipeline Normalizer transformation.
Create one or more target definitions from a mapplet instance in a mapping.
When you create a target definition from a transformation, the target database type is the same as the repository database by default. After you create the target definition in the repository, you can edit it. For example, you might want to change the target type.
If you need to create a target definition that contains columns from more than one transformation, you can copy the ports from each transformation to a transformation such as an Expression or Joiner. You can create the target definition from that transformation.
When you create a relational target definition, you must generate and execute the SQL to create the table in the target database.