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 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: