Ab initio Interview Questions

Ab initio Interview Questions And Answers

Below is the top Ab initio Interview Questions that are asked frequently in an interview. These Interview questions are divided into two parts are as follows:

Part 1 – Ab initio Interview Questions (Basic)

This first part covers basic Ab initio Interview Questions and Answers.

 1. What are the components or functions available in ab initio?

Answer:
The main components in ab initio are here below,

2. What are the types of parallel processing?

Answer:
This is the common Ab initio Interview questions asked in an interview. Different types of parallel processing are,

1. Component parallelism
2. Data parallelism
3. Pipeline parallelism

Component parallelism: An application that has multiple components running on the system simultaneously. But the data are separate. This is achieved through component level parallel processing.

Data parallelism: Data is split into segments and runs the operations simultaneously. This kind of process is achieved using the data parallelism

Pipeline parallelism: An application with multiple components but running on the same dataset. This uses pipeline parallelism.

3. What is the different way to achieve the partitions?

Answer:
There are multiple ways to do the partitions.

Let us move to the next Ab initio interview Questions.

4. What is a multifile system?

Answer:        
Multifile is a set of directories on different nodes in a cluster. They possess an identical directory structure. The multifile system leads to a better performance as it is parallel processing where the data resides on multiple disks.

It is created with the control partition on one node and data partitions on the other nodes to distribute the processing in order to improve the performance.

5. Difference between Hadoop and Ab initio?

Answer:

Part 2 – Ab initio Interview Questions (Advanced)

Let us now have a look at the advanced Ab initio Interview Questions.

6. What kind of layouts does Ab initio support?

Answer:

• Supports serial and parallel layouts.
• A graph layout supports both serial and parallel layouts at a time.
• A multi-file system is a 4-way parallel system
• A component in a graph system can run 4-way parallel system.

7. What is the relation between Enterprise metadata environment (EME), the Graphical development environment (GDE) and co-operating system?

Answer:
CoOperating System: It operates on top of the operating system and this is provided by the ab initio and it the base for all Ab Initio processes. Air commands are one of the features that can be installed on different operating systems like UNIX, Linux, IBM etc

These are the following features that it provides,
– Manages and runs Ab Initio graphs and control the ETL processes
– Providing the extensions
– ETL processes monitoring and debugging
– Metadata management and interaction with the EME

GDE: It’s a designing component and used to run the ab initio graphs.

Graphs are formed by the components (predefined or user-defined) and flows and the parameters. It provides the ETL process in Ab Initio that is represented by graphs.

Ability to run, debug the process logs jobs and trace execution logs

Enterprise Meta-Environment (EME): It’s an environment for storage and also metadata management (Both business and technical metadata). The metadata is accessed from the graphical development environment and also the web browser or the cooperating command line. It is ab initio repository for any placeholders.

Let us move to the next Ab initio interview questions.

8.How data is processed and what are the fundamentals of this approach?

Answer:
There are certain activities which require the collection of the data and the best thing is processing largely depends on the same in many cases. Before processing the data it has to reside on some placeholder like a well-defined storage. This task depends on some major factors are they are

1. Collection of Data
2. Presentation
3.Final Outcomes
4.Analysis
5.Sorting

9. What is the difference between partitioning with key and round robin?

Answer :
This is the advanced Ab initio interview questions asked in an interview. Partition by key
In this, we have to specify the key based on which the partition will occur.  It results in well-balanced data due to the key based partitions. It is useful for key dependent
parallelism.
Partition by round robin: In this, distributing data evenly in block size chunks the records are partitioned in a sequential way across the output partition. It is not key
based and results are well-balanced data especially with a block size of 1. It is useful for
record independent parallelism.

10. How do you improve the performance of a graph?

Answer:
There are many ways the performance of the graph can be improved.
1) Reduce the usage of multiple components on certain phases.
2) Use a refined and well defined value of max core values for sort and join components
3) Minimize the use of regular expression functions like re_index in the transfer functions
4) Minimize sorted join component and if possible replace them by in-memory join/hash join
5) Use only required fields in the sort, reformat, join components
6) Using Phase or the flow buffering during the cases of merge or sorted joins
7) Use hash join if the two sets of input is small else better to choose the sorted join for the huge input size
8) For large dataset better not use broadcast as partitioned
9) Reduce the number of sort components while processing.
10) Avoid repartitioning of data unnecessarily

Recommended Article

This has been a guide to List Of Ab initio Interview Questions and Answers so that the candidate can crackdown these Ab initio Interview Questions easily. Here in this post, we have studied about top Ab initio Interview Questions which are often asked in interviews. You may also look at the following articles to learn more –

1. Android Interview Questions – Top 10 Useful Question
2. Statistics Interview Questions | Useful And Most Asked
3. Minitab Interview Questions – Top 7 Useful Questions To Learn
4. Splunk Interview Questions And Answers You Should Know