During ETL load we generally have

To answer this question, the user needs to know the basic concepts of ETL (Extract, Transform, and Load) process and Aggregation.

Aggregation is a process of summarizing and grouping data from multiple sources into a single unit. It is used to obtain insights into underlying patterns and trends in the data.

During the ETL load process, the data is extracted from various sources, transformed and then loaded into a target system. The transformation process includes various operations, including sorting, filtering, and aggregation.

Now, let's go through each option and explain why it is right or wrong:

A. Unsorted data for Aggregator: This option is incorrect because unsorted data cannot be used for aggregation. Aggregation requires similar data to be grouped and summarized, which is not possible with unsorted data.

B. Sorted data for Aggregator: This option is correct. Sorting the data before aggregation can improve the performance of the aggregation process. It helps in grouping the data more efficiently and reduces the amount of data that needs to be processed.

C. Does not matter if we use Sorted or Unsorted data for Aggregation: This option is incorrect. The performance of the aggregation process is affected by the input data. Using unsorted data can result in slower processing times and inefficient memory usage.

D. None of the above: This option is incorrect because option B is the correct answer.

Therefore, the answer is: B. Sorted data for Aggregator.