# Ab Initio Interview Questions For Experienced

Ab Initio Interview Questions, Abinitio Interview Questions and Answers For Experienced. Here Codingcompiler sharing a Real-time Abinitio scenario based interview questions. These advanced Abinitio questions will help you to crack your next Ab Initio job interview. All the best for your future and happy learning.

## Ab Initio Interview Questions

Ab-Initio Interview Questions

1. What Is Abinitio?
2. Describe The Evaluation Of Parameters Order in Ab Initio?
3. Explain How Abinitio Eme Is Segregated?
4. Explain How You Can Run A Graph Infinitely In Ab Initio?
5. Explain Pdl With An Example?
6. Explain The Methods To Improve Performance Of A Graph?
7. Explain What Does Dependency Analysis Mean In Abinitio?
8. Explain What Is De-partition In Abinitio?
9. Explain What Is Sandbox?
10. Explain What Is Sort Component In Abinitio?
11. Explain What Is The Architecture Of Abinitio?
12. How Do You Add Default Rules In Transformer?
13. How To Add Default Rules In Transformer?
14. How To Run A Graph Infinitely?
15. List Out Some Of The Air Commands Used In Abintio?

## Ab Initio Interview Questions And Answes

1) Can explain the Ab Initio ETL tool in high level?

A) Abinitio is an ETL tool. Ab Initio ETL tool is used to extract, transform and load data.

2) What are the six data process products of Ab Initio (Architecture of Ab Initio)?

A) Ab Initio comprised of six data processing products. They are:

1) Co>Operating System,
2) The Component Library,
3) Graphical Development Environment,
4) Enterprise Meta>Environment,
5) Data Profiler,
6) Conduct>It.

3) What is the use of The Co> Operating System in Ab Initio?

A) The Co> Operating System is an environment to build, integrate and run business applications. It is the base that supports all Ab Initio technologies, such as Enterprise Meta> Environment, Continuous> Flows, Conduct> It, Business Rules Environment, among others. These technologies provide a complete and seamless environment for the development and execution of applications.

4) What is the core of Co> Operating System?

A) The core of the Co> Operating System is a “data flow engine”. This engine feeds an extensive library of “components” for data processing, which manipulate the data that flows through an application. Applications are designed, implemented and maintained in a graphical environment using the Ab Initio Graphical Development Environment (GDE).

5) What are the features of Ab Initio?

A) The ability to graphically and easily express large amounts of complex logic;

Practically full connectivity; a wide range of databases, queue systems, flat files, ERP systems, standard message protocols and more;

Native support for complex data structures; any kind of data from any source; hierarchical (XML and inherited), international, large objects, variable length, data in bit-packed format and many more;

Support for a wide range of operating systems (Unix, Linux, Windows, mainframe) and distributed processing on all these platforms;

Open architecture for rapid integration with legacy and third-party applications, data and environments;

High efficiency and high scalability, together with the ability to enable computing similar to “cloud” computing in server networks;

High-performance, real-time batch processing (web services and service-oriented architectures (SOA), as well as streaming);

High degree of reuse of large and small fragments of applications, including business rules.

High resistance against data problems and system failures; strong user control against error response;

Comprehensive management capabilities; support for the software development life cycle, including version control and version promotion; programming, monitoring and execution notices; Application analysis and much more.

6) What is is a data flow graph?

A) The core of an Ab Initio application is a data flow graph (or a “graph”, according to the abbreviated expression). A graph consists of components that are connected by “flows” of data.

7) Can you explain data flow graph with an example?

A) A simple application that first reads each record from a flat file containing customer transactions. The application then reformats the data (applying rules) before ordering. Next, the application groups (or aggregates) the data. Next, the results of this processing are written to a table in a database, such as Oracle.

8) What are the fundamental blocks of Co> Operating System of Ab Initio?

A) The Co> Operating System of Ab Initio provides the fundamental functional blocks for the processing of business data. Namely:

• data transformations;
• selection / filtering;
• deduplication;
• union / fusion;
• normalization / normalization;
• compression / decompression;
• aggregation / scanning;
• ordination;
• data generation and validation & others.

9) What are the Co> Operating System’s assorted library of integrated components?

A) The Co> Operating System is distributed with an assorted library of integrated components that allows you to process virtually any type of data source or destination. This library includes components for:

Connect to any kind of flat file on Unix, Windows and mainframes;
connect to all common and some less common databases (Oracle, DB2, Teradata, SQL Server, Netezza, Greenplum, DB2 mainframe, IMS, IDMS, Adabas, …);

Connect to all standard message queue infrastructures (IBM MQ, JMS, Microsoft MQ);

Connect to web services infrastructures (WebSphere, WebLogic, IIS, Apache / Tomcat, …);

Connect with many third-party products (SAP, Siebel, SAS, PeopleSoft, Salesforce.com, …);

Analysis and manipulation of hierarchical data structures (XML, ASN.1, Cobol, …);

Analysis, manipulation and generation of data formats specific to a domain (Swift, FIX, EDIFACT, …);

Content-based message routing;

Metadata connectivity with a wide range of data definitions and business intelligence products (ERWin, ERStudio, Microstrategy, Business Objects, Cognos, …).

Small applications can have between three and five components. Large applications can have up to a hundred components. Very large applications can have many thousands of components. Applications can also consist of many graphs, each of which can in turn have many components.

10) How Co> Operating System natively processes the data?

A) With Ab Initio, the data is exactly what the Co> Operating System or the user wants them to be. And this is possible because the Co> Operating System does not need to convert the data to a specific and limited set of integrated formats.

Instead, the Co> Operating System processes the data in its native format (and also processes it in any of the compatible operating systems). The Co> Operating System, like the rest of the Ab Initio components, can natively process mainframe data on Unix and Windows servers, XML on mainframes, complex hierarchical and bit-packed structures, international data with automatic transcoding, and so on. successively. From the same data, the Co> Operating System will generate identical results.

11) Can you explain the performance and scalability of Co> Operating System?

A) The Co>Operating System was designed from the ground up to achieve maximum performance and scalability. Every aspect of the Co>Operating System has been optimized to get maximum performance from your hardware. And you don’t need “cloud” technology because the Co>Operating System naturally distributes processing across farms of servers.

12) Can you explain the Co>Operating System’s processing model?

A) The Co>Operating System is a distributed peer-to-peer processing system. It must be installed on all the servers that will be part of running an application. Each of these servers may be running a different operating system (Unix, Linux and zLinux, Windows, or z/OS).

13) How Co>Operating System Integrates with legacy codes?

A) Ab Initio enables to build end-to-end applications completely with the Graphical Development Environment, and run those applications completely within the Co>Operating System, users often have existing applications or 3rd party products that run fine and that are not worth re-implementing.

Ab Initio makes it easy to reuse those existing applications, whether they were coded in C, C++, Cobol, Java, shell scripts, or whatever. In fact, the Co>Operating System makes it possible to integrate those applications into environments they were not originally designed for.

Legacy codes are integrated into Ab Initio applications by turning them into components that behave just like all other Ab Initio components.

14) What is Ab Initio Enterprise Meta>Environment (EME)?

A) Ab Initio Enterprise Meta>Environment (EME), a centralized repository, and reused both within and across applications.

15) What you can store, manage and reuse centrally in Ab Initio Enterprise Meta>Environment (EME)?

A) Here are the elements of what we can centrally store, manage, and reuse:

• Record formats
• Sections of applications (applications are called “graphs” and the sections are called “subgraphs”)
• Orchestrations of applications (“plans” in Ab Initio’s Conduct>It)

16) What metadata importer can do in Ab Initio?

Reporting tools: MicroStrategy, Business Objects, Cognos, …
Modeling tools: ERwin, ERstudio, and Rational Architect, …
Database system catalogs for all major and most minor relational database management systems
Tabular metadata, usually stored in spreadsheets using either predefined templates or customer-specific layouts
Industry-standard protocols for metadata exchanges, including Common Warehouse Model XML Metadata Interchange Format (CWM XMI)

17) What is the Ab Initio Business Rules Environment (BRE)?

The Ab Initio® Business Rules Environment (BRE) allows business analysts to specify business rules in a form that is very familiar and comfortable to them: grid-like spreadsheets.

In the BRE, the rules are specified in business terms, not technical terms, and with expressions that are clear to anyone who has worked with Microsoft Excel. As a consequence, not only can rules be specified quickly and accurately, they are also easily understood by other business people.

18) What are “business rules” in Ab Initio Business Rules Environment (BRE)?

A) The BRE supports three different styles of business rules: decision rules, validation rules, and mapping rules. While they are fundamentally similar, business users are comfortable thinking of rules as belonging in one of these categories.

19) How does the BRE work with the Co>Operating System?

A) It’s straightforward: the BRE takes the rules created by the user and puts them into a component in a graph run by the Co>Operating System.

20) What is Conduct>It?

A) Ab Initio Conduct>It is a high-volume data processing systems developing tool. It enables combining graphs from Graphical Development Environment with custom scripts and programs from other vendors.

### Advanced Ab Initio Interview Questions For Experienced

• List Out The File Extensions Used In Abinitio?
• Mention How Can You Connect Eme To Abinitio Server?
• Mention What Are The Different Types Of Parallelism Used In Abinitio?
• Mention What Dedup-component And Replicate Component Does?
• Mention What Information Does A .dbc File Extension Provides To Connect To The Database?

Mention What Is A Partition And What Are The Different Types Of Partition Components In Abinitio?
Mention What Is Rollup Component?
Mention What Is The Role Of Co-operating System In Abinitio?
Mention What Is The Syntax For M_dump In Abinitio?
Mention What The Difference Between “look-up” File And “look Is Up” In Abinitio?
State The First_defined Function With An Example?
State The Relation Between Eme, Gde And Co-operating System?
State The Working Process Of Decimal_strip Function?

### Ab Initio Scenario Based Interview Questions

We Know Rollup Component In Abinitio Is Used To Summarize Group Of Data Record Then Why Do We Use Aggregation?
What Are The Operations That Support Avoiding Duplicate Record?
What Is A Deadlock And How It Occurs?
What Is A Local Lookup?
What Is A Look-up?
What Is A Ramp Limit?
What Is A Rollup Component? Explain About It.
What Is Max Core Of A Component?
What Is The Difference Between Check Point And Phase?
What Is The Difference Between Partitioning With Key / Hash And Round Robin?
What Is The Function That Transfers A String Into A Decimal?
What Kind Of Layouts Does Abinitio Support?
What Parallelisms Does Abinitio Support?

Related Post: Ab Initio Sample Resumes