The Consolidation transformation uses standard Informatica sorting techniques. By default, the techniques give the transformation as much memory as possible without affecting system performance.
You can set a limit on the amount of main memory that the transformation uses to sort data. This increases on-disk temporary memory use, as the transformation must store all data rows.
You cannot partition a Consolidation transformation.