+91 90691 39140 | +1 253 214 3115 | info@hub4tech.com | hub4tech

Abinitio Interview Questions and Answers

1
We know rollup component in Abinitio is used to summarize group of data record then why do we use aggregation?
  • Aggregation and Rollup, both are used to summarize the data.
  • Rollup is much better and convenient to use.
  • Rollup can perform some additional functionality, like input filtering and output filtering of records.
  • Aggregate does not display the intermediate results in main memory, where as Rollup can.
  • Analyzing a particular summarization is much simpler compared to Aggregations.
2
Mention what is Abinitio?

“Abinitio” is a latin word meaning “from the beginning.” Abinitio is a tool used to extract, transform and load data. It is also used for data analysis, data manipulation, batch processing, and graphical user interface based parallel processing.

3
What are the operations that support avoiding duplicate record?

Duplicate records can be avoided by using the following:

  • Using Dedup sort
  • Performing aggregation
  • Utilizing the Rollup component
4
Mention what is Rollup Component?

Roll-up component enables the users to group the records on certain field values. It is a multiple stage function and consists initialize 2 and Rollup 3.

5
What kind of layouts does Abinitio support?
  • Abinitio supports serial and parallel layouts.
  • A graph layout supports both serial and parallel layouts at a time.
  • The parallel layout depends on the degree of the data parallelism
  • A multi-file system is a 4-way parallel system
  • A component in a graph system can run 4-way parallel system.
Copyright ©2015 Hub4Tech.com, All Rights Reserved. Hub4Tech™ is registered trademark of Hub4tech Portal Services Pvt. Ltd.
All trademarks and logos appearing on this website are the property of their respective owners.
FOLLOW US