Abinitio Interview Questions and Answers

Abinitio Interview Questions and Answers

The Ab Initio software is a fourth generation  data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing product which is commonly used to extract, transform, and load (ETL) data. Ab Initio Software is an American multinational enterprise software corporation based in Lexington, Massachusetts. The Company specializes in high-volume data processing applications and enterprise application integration. It was founded in 1995 by the former CEO of Thinking Machines Corporation, Sheryl Handler, and several other former employees after the bankruptcy of that company.

Can you explain Abinitio?

What is the architecture of Abinitio ETL?

What is the role of Co-operating system in Abinitio?

Can you explain AbInitio GDE?

Can you explain Component Library?

What are the layouts does Ab initio support?

What does dependency analysis mean in Abinitio?

Can you explain EME?

Can you define Data Profiler?

How Abinitio EME is segregated?

How can you connect EME to Abinitio Server?

What are the file extensions used in Abinitio?

What information does a .dbc file extension provides to connect to the database?

How you can run a graph infinitely in Abinitio?

Can you define SANDBOX?

Can you define multifile system?

What are the components or functions available in ab initio?

How can you run a graph infinitely?

Can you explain the different types of parallelism used in Abinitio?

Can you explain Sort Component?

What is the difference between dedup-component and replicate component?

Can you define partition and what are the different types of partition components in Abinitio?

Can you explain de-partition in Abinitio?

What are the air commands used in Abinitio?

Can you explain Rollup Component?

What is the difference between rollup and scan?

What is the syntax for m_dump in Abinitio?

What is the relation between EME, GDE and co-operating system?

How can you run a graph infinitely?

How do you add default rules in transformer?

Can you explain local lookup is?

What is the difference between look-up file and look-up, with a relevant example?

What is lookup?

Can you define outer join?

Can you explain improve the performance of a graph?

How do you truncate a table?

What is the difference between a DB config and a CFG file?

Can you explain data mapping?

Can you explain the Graph parameter?

Can you explain the layouts does Abinitio supports?

Can you explain primary keys and foreign keys?

Can you explain Cartesian joins?

How do you truncate a table?

How to run the graph without GDE?

How can I run the 2 GUI merge files?

Can you explain .abinitiorc ?

Can you explain local and formal parameter?

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

Can you explain add default rules in transformer?