What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?



What is the use of aggregation when we have rollup as we know rollup component in abinitio is used t..

Answer / Gaurav Agarwal

While both Rollup and Aggregation components in Ab Initio are used for summarizing data, they serve slightly different purposes. Rollup focuses on providing detailed summary statistics (such as minimum, maximum, average, sum, count) for a single group of records. In contrast, Aggregation can perform more complex calculations that involve multiple groups or datasets. For example, you might use aggregation to calculate the total sales for each region, while using rollup to summarize individual transactions within each region.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Ab Initio Interview Questions

How many parallelisms are in Abinitio?

3 Answers  


How will you check the latest versions in EME?

6 Answers  


What metadata importer can do in ab initio?

1 Answers  


What is publickey and private key?what is the use of this two keys?

1 Answers  


the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?

5 Answers   EDS,


what is the difference between .dbc and .cfg file?

3 Answers   Cap Gemini,


what is environment variables and parameters?

1 Answers  


How to connect mainframe to Abinitio?

1 Answers   CTS,


How to get DML using Utilities in UNIX?

1 Answers  


What is the difference between partitioning with key / hash and round robin?

1 Answers  


What is the DynamicScriptGeneration and what is the Use?

2 Answers  


what is the difference between the .dbc and .cfg extensions and give any clear information ?

4 Answers   Cognizant,


Categories