Information Server metadata repository

In the file system as a binary file

In the file system as a csv file

None of the above

DataStage Administrator client only

DataStage Administrator or Director client

DataStage Director client only

DataStage Designer or Director client.

If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays together

If the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay together

If the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order to have correct results

ROUND ROBIN ensures correct results