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. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Creating a Target Definition from a Transformation

Creating a Target Definition from a Transformation

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:
  • Single-group transformations.
    Create a single target definition from a transformation with one output group.
  • Multiple-group transformations.
    Create multiple target definitions from a transformation with multiple output groups.
  • Normalizer transformations.
    Create a target definition from a source qualifier or pipeline Normalizer transformation.
  • Mapplets.
    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.

Updated March 29, 2021