Ab Initio Interview Questions and Answers, Ab Initio Interview Questions and Answers Freshers, Ab Initio Interview Questions and Answers, Ab Initio Interview Questions

Before getting on to the Ab Initio interview questions, the student must know that the Ab Initio is a continuously varying field which needs the students as well as professionals to upgrade their skills with the new features and knowledge, to get fit for the jobs associated with Ab Initio. This post related to Ab Initio Interview Questions and Answers, Ab Initio Interview Questions and Answers Freshers, Ab Initio Interview Questions and Answers, Ab Initio Interview Questions will help you let out find all the solutions that are frequently asked in you upcoming Ab Initio interview.

Over thousands of vacancies available for the Ab Initio developers, experts must be acquaintance with all the component of Ab Initio technologies. This is necessary for the students in order to have in-depth knowledge of the subject so that they can have best employment opportunities in the future. Knowing every little detail about Ab Initio is the best approach to solve the problems linked with problem.

APTRON has spent hours and hours in researching about the Ab Initio Interview Questions and Answers, Ab Initio Interview Questions and Answers Freshers, Ab Initio Interview Questions and Answers, Ab Initio Interview Questions that you might encounter in your upcoming interview.  All these questions will alone help you to crack the interview and make you the best among all your competitors.

First of all, let us tell you about how the Ab Initio technology is evolving in today’s world and how demanding it is in the upcoming years. In fact, according to one study, most of the companies and businesses have moved to the Ab Initio. Now, you cannot predict how huge the future is going to be for the people experienced in the related technologies.

Hence, if you are looking for boosting up your profile and securing your future, Ab Initio will help you in reaching the zenith of your career. Apart from this, you would also have a lot of opportunities as a fresher.

These questions alone are omnipotent. Read and re-read the questions and their solutions to get accustomed to what you will be asked in the interview. These Ab Initio interview questions and answers will also help you on your way to mastering the skills and will take you to the giant world where worldwide and local businesses, huge or medium, are picking up the best and quality Ab Initio professionals.

This ultimate list of best Ab Initio interview questions will ride you through the quick knowledge of the subject and topics like Abinitio Architecture, Graph Programming, Introduction to .dat and .dml files. This Ab Initio interview questions and answers can be your next gateway to your next job as a Ab Initio expert.

These are very Basic Ab Initio Interview Questions and Answers for freshers and experienced bot

Q1: Mention what is Abinitio?
A1: “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.

Q2: Explain what is the architecture of Abinitio?
A2: Architecture of Abinitio includes

  • GDE (Graphical Development Environment)
  • Co-operating System
  • Enterprise meta-environment (EME)
  • Conduct-IT

Q3: Explain how Abinitio EME is segregated?
A3: Abinition is logically divided into two segments

  • Data Integration Portion
  • User Interface ( Access to the meta-data information)

Q4: List out the file extensions used in Abinitio?
A4: The file extensions used in Abinitio are

  • .mp: It stores Ab initio graph or graph component
  • .mpc: Custom component or program
  • .mdc: Dataset or custom data-set component
  • .dml: Data manipulation language file or record type definition
  • .xfr: Transform function file
  • .dat: Data file (multifile or serial file)

Q5: Mention what are the different types of parallelism used in Abinitio?
A5: Different types of parallelism used in Abinitio includes

  • Component parallelism:A graph with multiple processes executing simultaneously on separate data uses parallelism
  • Data parallelism:A graph that works with data divided into segments and operates on each segments respectively, uses data parallelism.
  • Pipeline parallelism:A graph that deals with multiple components executing simultaneously on the same data uses pipeline parallelism. Each component in the pipeline read continuously from the upstream components, processes data and writes to downstream components.  Both components can operate in parallel.

Q6: List out some of the air commands used in Abintio?
A6: Air command used in Abinitio includes

  • air object Is<EME path for the object-/Projects/edf/..>:  It is used to see the listings of objects in a directory inside the project
  • air object rm<EME path for the object-/Projects/edf/..>: It is used to remove an object from the repository
  • air object versions-verbose<EME path for the object-/Projects/edf/..>: It gives the version history of the object.

Other air command for Abinitio include air object cat, air object modify, air lock show user, etc.

Q7: Mention what is the syntax for m_dump in Abinitio?
A7: The syntax for m_dump in Abinitio is used to view the data in multifile from unix prompt. The command for m_dump includes

  • m_dump a.dml a.dat:This command will print the data as it manifested from GDE when we view data in formatted text
  • m_dump a.dml a.dat>b.dat:The output is re-directed in b.dat and will act as a serial file.b.dat that can be referred when it is required.

Q8: What are the benefits of data processing according to you?
A8: Well, processing of data derives a very large number of benefits. Users can put separate many factors that matters to them. In addition to this, with the help of this approach, one can easily keep up the pace simply by deriving data into different structures from a totally unstructured format. In addition to this, processing is useful in eliminating various bugs that are often associated with the data and cause problems at a later section. It is because of no other reason than this, data processing has wide application in a number of tasks.

Q9: What are the factors on which storage of data depends?
A9: Basically, it depends on the sorting and filtering. In addition to this, it largely depends on the software one uses.

Q10: Suppose you find the term Validation mentioned with a set of data, what does that simply represent?
A10: It represents that the concerned data is clean, correct and can thus be used reliably without worrying about anything. Data validation is widely regarded as the key points in the processing system.

Q11: What are the benefits of data analyzing
A11: It makes sure of the following:

  1. Explanation of development related to the core tasks can be assured
  2. Test Hypotheses with an integration approach is always there
  3. Pattern detection in a reliable manner

Q12: What do you mean by the overflow errors?
A12: While processing data, calculations which are bulky are often there and it is not always necessary that they fit the memory allocated for them. In case a character of more than 8-bits is stored there, this errors results simply

Q13: What is data encoding?
A13: Data needs to be kept confidential in many cases and it can be done through this approach. It simply make sure of information remains in a form which no one else than the sender and the receiver can understand.

Q14: What does EDP stand for?
A14: It means Electronic Data Processing

Q15: What is a ramp limit?
A15: – A limit is an integer parameter which represents a number of reject events

– Ramp parameter contain a real number representing a rate of reject events of certain processed records

– The formula is – No. of bad records allowed = limit + no. of records x ramp

– A ramp is a percentage value from 0 to 1.

– These two provides the threshold value of bad records.

Q16: Describe the Evaluation of Parameters order.
A16: Following is the order of evaluation:

– Host setup script will be executed first

– All Common parameters, that is, included , are evaluated

– All Sandbox parameters are evaluated

– The project script – project-start.ksh is executed

– All form parameters are evaluated

– Graph parameters are evaluated

– The Start Script of graph is executed

Q17: What parallelisms does Abinitio support?
A17: AbInitio supports 3 parallelisms. They are

– Data Parallelism : Same data is parallelly worked in a single application

– Component Parallelism : Different data is worked parallelly in a single application

– Pipeline Parallelism : Data is passed from one component to another component. Data is worked on both of the components.

Q18: What is the difference between check point and phase?
A18: Check point:

– When a graph fails in the middle of the process, a recovery point is created, known as Check point

– The rest of the process will be continued after the check point

– Data from the check point is fetched and continue to execute after correction.


– If a graph is created with phases, each phase is assigned to some part of memory one after another.

– All the phases will run one by one

– The intermediate file will be deleted

Q19: What is MAX CORE of a component?

– MAX CORE is the space consumed by a component that is used for calculations

– Each component has different MAX COREs

– Component performances will be influenced by the MAX CORE’s contribution

– The process may slow down / fasten if a wrong MAX CORE is set

Q20: How to run a graph infinitely?

To run a graph infinitely…

– The .ksh graph file should be called by the end script in the graph.

– If the graph name is abc.mp then the graph should call the abc.ksh file.

Q21: What is a local lookup?
A21: – Local lookup file has records which can be placed in main memory

– They use transform function for retrieving records much faster than retrieving from the disk.

Q22: How do you add default rules in transformer?
A22: The following is the process to add default rules in transformer

– Double click on the transform parameter in the parameter tab page in component properties

– Click on Edit menu in Transform editor

– Select Add Default Rules from the dropdown list box.

– It shows Match Names and Wildcard options. Select either of them.

Q23: We know rollup component in Abinitio is used to summarize group of data record then why do we use aggregation?
A23: – 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.

Q24: What kind of layouts does Abinitio support?
A24: – 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.

Ab Initio Conclusion Interview FAQs

We know the list of Ab Initio Interview Questions and Answers, Ab Initio Interview Questions and Answers Freshers, Ab Initio Interview Questions and Answers, Ab Initio Interview Questions is overwhelming but the advantages of reading all the questions will maximize your potential and help you crack the interview. The surprising fact is that this Ab Initio interview questions and answers post covers all the basic of the Ab Initio technology and you have to check out the FAQs of different components of Ab Initio too.

However, you will be asked with the questions in the interview related to the above mentioned questions. Preparing and understanding all the concept of Ab Initio technology will help you strengthen the other little information around the topic.

After preparing these interview questions, we recommend you to go for a mock interview before facing the real one. You can take the help of your friend or a Ab Initio expert to find the loop holes in your skills and knowledge. Moreover, this will also allow you in practicing and improving the communication skill which plays a vital role in getting placed and grabbing high salaries.

Remember, in the interview, the company or the business or you can say the examiner often checks your basic knowledge of the subject. If your basics is covered and strengthened, you can have the job of your dream. The industry experts understand that if the foundation of the student is already made up, it is easy for the company to educate the employ towards advance skills. If there are no basics, there is no meaning of having learnt the subject.

Therefore, it’s never too late to edge all the basics of any technology. If you think that you’ve not acquired the enough skills, you can join our upcoming batch of Ab Initio Training in Noida. We are one of the best institute for Ab Initio in noida which provide advance learning in the field of Ab Initio Course. We’ve highly qualified professionals working with us and promise top quality education to the students.

We hope that you enjoyed reading Ab Initio Interview Questions and Answers, Ab Initio Interview Questions and Answers Freshers, Ab Initio Interview Questions and Answers, Ab Initio Interview Questions and all the FAQs associated with the interview. Do not forget to revise all the Ab Initio interview questions and answers before going for the Ab Initio interview. In addition to this, if you’ve any doubt or query associated with Ab Initio, you can contact us anytime. We will be happy to help you out at our earliest convenience. At last, we wish you all the best for your upcoming interview on Ab Initio Technology.