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

Creating a Target from a Transformation with Multiple Output Groups

Creating a Target from a Transformation with Multiple Output Groups

When you create targets from a transformation with more than one output group, the Designer creates one target for each output group in the transformation. When the transformation is a plug-in or Custom transformation, the Designer retains the primary key-foreign key relationships between the groups in the target definitions.
The following figure shows a transformation with multiple output groups:
The transformation is the Employees XML Parser transformation.
The Employees XML Parser transformation has five output groups, from X_emp_EMPLOYEES to X_emp_PHONE. Each output group represents different types of employee information. DataInput is the input group.
When you create a target from this transformation, the Designer creates a separate target for each output group. Each target has the corresponding group name from the transformation group, as shown in the following figure:
The targets are Employees_X_emp_EMPLOYEES, Employees_X_emp_PHONE, Employees_X_emp_SALARY, and Employees_X_emp_EMAIL.

Updated July 02, 2020