Consolidation Transformation Ports
The Developer tool creates an output port for each input port that you add. You cannot manually add output ports to the transformation. The Consolidation transformation also includes an IsSurvivor output port that indicates the consolidated records.
One of the input ports that you add to the Consolidation transformation must contain group keys. The Consolidation transformation requires group key information because consolidation strategies process record groups rather than entire datasets.
When you add an input port, the Developer tool creates an output port name by adding the suffix "1" to the input port name. The transformation also includes the IsSurvivor output port, which indicates whether a record is the consolidated record. For consolidated records, the Consolidation transformation writes the string "Y" to the IsSurvivor port. For input records, the Consolidation transformation writes the string "N" to the IsSurvivor port.