EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 600+ Courses All in One Bundle
  • Login
Home Software Development Software Development Tutorials Top Interview Question Ab Initio Interview Questions
Secondary Sidebar
Top Interview Question Tutorial
  • Interview Questions
    • Apache PIG Interview Questions
    • Elasticsearch Interview Questions
    • Data Engineer Interview Questions
    • Algorithm Interview Questions
    • OBIEE Interview Question
    • SSIS Interview Questions
    • Cognos Interview Questions
    • MapReduce Interview Questions
    • NoSQL Interview Questions
    • SharePoint Interview Questions
    • Sqoop Interview Questions
    • Business Intelligence Interview Questions
    • Mainframe Interview Questions
    • Rail Interview Questions
    • SSRS Interview Questions
    • Data Modeling Interview Questions
    • J2EE Interview Questions
    • Minitab Interview Questions
    • Statistics Interview Questions
    • MS SQL Interview Questions
    • Ab Initio Interview Questions
    • Spark Interview Questions
    • WordPress Interview Questions
    • OS Interview Questions
    • Drupal Interview Questions
    • OOP Interview Questions
    • Mulesoft Interview Questions
    • Typescript Interview Questions
    • Redux Interview Questions
    • Pig Interview Questions
    • ES6 Interview Questions
    • Multithreading Interview Questions
    • Go Interview Questions
    • APEX Interview Questions
    • Teradata Interview Questions
    • Groovy Interview Questions
    • ExtJS Interview Questions
    • E-Commerce Interview Questions
    • Appium Interview Questions
    • SOA Interview Questions
    • ITIL Interview Questions
    • Digital Electronics Interview Questions
    • IT Interview Questions
    • WinForms Interview Questions
    • IT Security Interview Questions
    • WCF Interview Questions
    • Microprocessor Interview Questions
    • Apache Interview Questions
    • MicroStrategy Interview Questions
    • Virtualization Interview Questions
    • UI Developer Interview Questions
    • Electrical Engineering Interview Questions
    • RMAN Interview Questions
    • SVN Interview Questions
    • Talend interview questions
    • SAP ABAP Interview Questions
    • Inheritance Interview Questions
    • Threading Interview Questions
    • Quality Control Interview Questions
    • Embedded System Interview Questions
    • OpenStack Interview Questions
    • Objective C Interview Questions
    • QA Interview Question
    • PLC Interview Questions
    • SDET Interview Questions
    • JCL Interview Questions
    • SOAP Interview Questions
    • IELTS Interview Questions
    • SoapUI Interview Questions
    • Front end Developer Interview Questions
    • DB2 Interview Questions
    • VSAM Interview Question
    • MVC Interview Questions
    • WPF Interview Questions
    • Java Collections Interview Questions
    • UI Designer Interview Questions
    • NLP Interview Questions
    • TFS Interview Questions
    • Active Directory Interview Questions
    • Xamarin Interview Questions
    • Intrusion Prevention System Interview Questions
    • COBOL Interview Questions
    • Control System Interview Questions
    • Blue Prism Interview Questions
    • Scenario Interview Questions
    • Unit testing interview questions
    • Linked List Interview Questions
    • Mainframe testing interview questions
    • Selenium Interview Questions
    • Binary Tree Interview Questions
    • Cloud Security Interview Questions
    • Functional Testing Interview Questions
    • Civil Engineering Questions for Interview
    • DHCP interview questions
    • Spring Batch Interview Questions
    • Perl interview questions
    • ESL interview questions
    • OBIEE Interview Questions
    • DynamoDB interview questions
    • Automation Anywhere Interview Questions
    • Scrum Interview Questions
    • Security Testing Interview Questions
    • Struts Interview Questions
    • Databricks Interview Questions
    • Electronics Engineering Interview Questions
    • Java concurrency interview questions
    • RxJava Interview Questions
    • ServiceNow Interview Question
    • XML Interview Questions
    • Entity Framework Interview Questions
    • Terraform Interview Questions
    • LINQ Interview Questions
    • MVVM Interview Questions
    • OSPF Interview Questions
    • Server interview questions
    • Appdynamics Interview Questions
    • Webpack Interview Questions
    • Data Architect Interview Questions
    • GitHub Interview Questions
    • Data Analyst Technical Interview Questions
    • GitHub JavaScript Interview Questions
    • Bitbucket Interview Questions
    • OOPs Java Interview Questions
    • DNS Interview Question
    • MPLS Interview Questions
    • Django Interview Question

Related Courses

Programming Languages Course

C programming Course

Selenium Training Certification

Ab Initio Interview Questions

By Priya PedamkarPriya Pedamkar

Ab initio Interview Questions

Ab initio Interview Questions And Answers

So you have finally found your dream job in Ab initio but are wondering how to crack the Ab initio Interview and what could be the probable Ab initio Interview Questions for 2023. Every interview is different, and the scope of a job is different too. Keeping this in mind, we have designed the most common Ab initio Interview Questions and  Answers for 2023 to help you get success in your interview.

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,

Component Purpose
Dedup To remove duplicates
Join To join multiple input dataset based on a common key value.
Sort This component reorders the data. It takes the collation order and dumps data to memory.
Filter Any conditional related removal of data.
Replicate This is component is mainly for parallelism as an additional copy of data is useful while any other nodes go unavailable.
merge This component is to combine multiple input data.

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:

Start Your Free Software Development Course

Web development, programming languages, Software testing & others

  • 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 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.

Partitions Description
Expression Data split according to the data manipulation language.
Key Grouping the data by specific keys
Load balance Dynamic load balancing
Percentage Segregate the data where the output size is on the fractions of 100
Range Split the data evenly based on a key and a range among the nodes
Round robin Distributing the data evenly in blocksize across the output 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 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:

Hadoop Ab initio
Open-source Proprietary software
Parallel processing through mappers and reducers Parallel processing architecture
Any variety of data is best suited here. Best for traditional EDW implementations
Fault tolerance is achieved Fault tolerance is not achieved
MapReduce is controlled on any components or functions Components like join, group, sort are easily

performed

Cheap as its open source and can try out any business use cases. Expensive and applicable to a high values business case because of the cost
Loosely coupled components where custom functions are built Tightly coupled between the components as they are highly recommended based on the business use case.

Part 2 – Ab initio Interview Questions (Advanced)

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

All in One Software Development Bundle(600+ Courses, 50+ projects)
Python TutorialC SharpJavaJavaScript
C Plus PlusSoftware TestingSQLKali Linux
Price
View Courses
600+ Online Courses | 50+ projects | 3000+ Hours | Verifiable Certificates | Lifetime Access
4.6 (86,697 ratings)

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 the 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 the ab initio provides this 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 an 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:
Certain activities 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 well-defined storage. This task depends on some major factors are they are

  • Collection of Data
  • Presentation
  • Final Outcomes
  • Analysis
  • 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.

  • Reduce the usage of multiple components on certain phases.
  • Use a refined and well-defined value of max core values for sort and join components.
  • Minimize the use of regular expression functions like re_index in the transfer functions
  • Minimize sorted join component and, if possible, replace them with in-memory join/hash join.
  • Use only required fields in the sort, reformat, join components.
  • Using Phase or the flow buffering during the cases of merge or sorted joins.
  • Use hash join if the two sets of input are small; else better to choose the sorted join for the huge input size.
  • For large dataset better not use broadcast as partitioned
  • Reduce the number of sort components while processing.
  • Avoid repartitioning of data unnecessarily.

Recommended Articles

This has been a guide to List Of Ab initio Interview Questions and Answers. Here we have listed the most useful 10 interview sets of questions so that jobseeker can crack the interview with ease. You may also look at the following articles to learn more –

  1. Android Interview Questions
  2. Statistics Interview Questions
  3. Minitab Interview Questions
  4. Splunk Interview Questions
Popular Course in this category
All in One Data Science Bundle (360+ Courses, 50+ projects)
  360+ Online Courses |  1500+ Hours |  Verifiable Certificates |  Lifetime Access
4.7
Price

View Course

Related Courses

Programming Languages Training (41 Courses, 13+ Projects, 4 Quizzes)4.9
C Programming Training (3 Courses, 5 Project)4.8
Selenium Automation Testing Training (11 Courses, 4+ Projects, 4 Quizzes)4.7
1 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Java Tutorials
  • Python Tutorials
  • All Tutorials
Certification Courses
  • All Courses
  • Software Development Course - All in One Bundle
  • Become a Python Developer
  • Java Course
  • Become a Selenium Automation Tester
  • Become an IoT Developer
  • ASP.NET Course
  • VB.NET Course
  • PHP Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Software Development Course

C# Programming, Conditional Constructs, Loops, Arrays, OOPS Concept

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Software Development Course

Web development, programming languages, Software testing & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more