Ab Initio interview questions with answers

Ab Initio is an American based company and their products focused on data processing with an easy to use user interface.Ab Initio is a multinational enterprise software corporation that is located in Lexington, Massachusetts, USA. The company’s main area of specialization is integration of enterprise application and applications for processing of high-volume data. The company was founded by Sheryl Handler (the former CEO of Thinking Machines Corporation) and several former employees, in 1995 after the company went bankrupt.

The applications execute functions that are related to the analysis of fourth generation data, processing of batch, manipulation of data, graphical user interface (GUI)-based parallel processing software which is often used for extracting, transforming and loading data.

The list of their products

  • Graphical Development Environment (GDE)
  • Business Rules Environment (BRE)
  • Enterprise Meta>Environment (EME)
  • Co>Operating System
  • Conduct>It
  • Data Profiler
  • the Component Library

Here I have collected some commonly asked interview questions based on Ab Initio products. I have not added the answers here, that you can google the questions and can find out the answer. Make sure prepare the answers for each questions before attending your Ab Initio job interview. You can also download the Ab Initio interview questions PDF version.

Ab Initio Interview Questions and Answers

Here are some possible interview questions and answer to expect when taking an Ab Initio examination:

  1. What is Ab Initio?


“Abinitio” is a Latin word which stands for “from the beginning”. Abinitio is a tool that helps in extracting, transforming and loading data. It can as well be used for analyzing data, processing batch, and processing of graphical user interface based parallel.

  1. What is de-partition?


De-partition is done for the purpose of reading data from multiple flow or operations and is used for rejoining data records from different flows. Numerous de-partition components are on hand, such as Merge, Concatenation, Gather, and Interleave.

  1. Describe the Grant/Revoke DDL facility and how it is implemented


It is a part of D.B.A responsibilities. GRANT means permissions. For instance, GRANT CREATE TABLE, CREATE VIEW AND MANY MORE

REVOKE, on the other hand, stands for cancel the grant (permissions). Therefore, Grant or Revoke both commands depend upon D.B.A.

  1. What is local lookup?


  • Local lookup file has records that you can place in main memory
  • Local lookup uses transform function to get back records quicker than having to retrieve them from the disk.
  1. What is Sort Component?


In Abinitio, the Sort Component re-orders data. It consists of two parameters – “Key” and “Max-core”.

  • Key: It is one of the parameters for sort component which helps in determining the collation order
  • Max-core: This parameter controls how frequently the sort component should dump data from memory to disk
  1. How can you force the optimizer to use a particular index?


Use hints /*+ <hint> */, they act as directives to the optimizer

  1. How do you run a graph infinitely?


To run a graph infinitely… The .ksh graph file needs to be called at the end script in the graph. If the name of the graph is xyz.mp then the graph should call the xyz.ksh file.

  1. What is Rollup parameter?


Roll-up component assists the users in grouping the records on certain field values. It is a multiple stage function and it comprises initial 2 and Rollup 3.

  1. What is local and formal parameter?


Both are graph level parameters. In local, you need to initialize the value at the declaration time whereas global does not need to initialize the data as it will prompt at the time of running the graph for that parameter.

10.What is SANDBOX?


A SANDBOX is referred for the collection of graphs and files related to it that are saved in a single directory tree and behaves as a group for the reason of navigation, version control and migration.

You should expect some questions about Graphs like how to run, performance improvement etc ..

4_Explain the methods to improve performance of a graph
5_How to find the number of arguments defined in graph
6_How to run a graph infinitely
7_an exaple of realtime start script in the graph
8_How to Improve Performance of graphs in Ab initioGive some examples or tips
9_How many components in your most complicated graph
10_How to run the graph without GDE
11_How would you do performance tuning for already built graph

Be prepare about the databases, there will be sure questions from there like Joins, Primary & Foreign Keys etc .

12_What are the most commonly used components in a Abinition graph
13_What are Cartesian joins
14_What is semi-join

Be thorough with each components of Ab-initio

15_What are the continuous components in Abinitio
16_How to retrieve data from database to source in that case whice component is used for this
17_What is a Rollup component
18_What is MAX CORE of a component

More References