The tool for scheduling purpose other than workflow manager can be a third party tool like ‘CONTROL M’.
Aggregator transformations are handled in chunks of instructions during each run. It stores transitional values which are found in local buffer memory. Aggregators provides extra cache files for storing the transformation values if extra memory is required.
There can be any number of repositories in informatica but eventually it depends on number of ports.
This happens when it faces DD_Reject in update strategy transformation. Moreover it disrupts the database constraint filed in the rows was condensed.