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?
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 |
How many parallelisms are in Abinitio?
How will you check the latest versions in EME?
What metadata importer can do in ab initio?
What is publickey and private key?what is the use of this two keys?
the inputs are 10,20,30,40,50 but the output was comes 0 records,the graph was failed what is bad situation?
what is the difference between .dbc and .cfg file?
what is environment variables and parameters?
How to connect mainframe to Abinitio?
How to get DML using Utilities in UNIX?
What is the difference between partitioning with key / hash and round robin?
What is the DynamicScriptGeneration and what is the Use?
what is the difference between the .dbc and .cfg extensions and give any clear information ?