Ab Initio Interview Questions

What are steps to create repository in AB Initio?

If you have installed AB Initio in a standalone machine, then there is no need to create a separate repository as it will be created automatically during the installation process. You could be able to view the newly created automated repository under AB Initio folder.


Explain about AB Initio's dependency analysis.

Dependency analysis in AB Initio is closely associated with data linage. Data linage provides the source for data and upon the implementation of dependency analysis, the type of applications dependent on the data can be identified. Dependency analysis also helps to carry out maximum retrieval operation (from existing data) by the use of surrogate key. New records can be generated when using scan or next_in_sequence/reformat sequence.


Write down the difference between 'delete' and 'truncate' commands?


Delete is a DML command

It is used to delete records, tables or clusters

Rollback and commit operations can be performed for the purpose of retrieving deleted things and to permanently delete things respectively

The execution of delete command is slower


Truncate is a DDL command

It is used to delete tables or clusters

The deployment of DDL command serves for auto commit operation. However, Rollback cannot be performed here.

Truncate command can be executed faster than delete command


Describe in detail about lookup?

A group of keyed dataset is said called lookup. The datasets in lookup can be classified into two types such as Static and Dynamic. In the case of dynamic datasets, the lookup file would be generated in the previous phase and used in the current phase. With respect to the data present in a particular multi/serial file, lookup can be used to map values.


Define ramp limit in AB Initio?

Generally, ramp is referred to the percentage value ranging from 0 to 1. For the purpose of representing the number of reject events, the limit parameter possess an integer called as ramp limit. The reject events can be calculated by the following formula,

Number of bad records allowed= Limit+ Number of records*Ramp


What are the different types of parallelism in AB Initio? Explain.

There are three types of parallelism such as,

Data parallelism

Pipeline parallelism and

Component parallelism

Data parallelism

A graph with divided segments from data operating on each segment at the same time employs data parallelism

Pipeline parallelism

A graph that consists of one or more components running at the same time on the same data makes use of pipeline parallelism

Component Parallelism

When a graph with one or more processes running simultaneously on individual data, then it uses component parallelism.