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.