Latest Questions
Post Top Ad
Your Ad Spot
Wednesday, June 26, 2019

25 Top Ab Initio Interview Questions and Answers {Updated}

Ab Initio Interview Questions and Answers for experienced PDF, Read commonly asked Ab Initio Job Interview Questions with Answers PDF for Freshers.

Read Ab Initio Interview Questions and Answers

Explain the difference between the truncate and delete commands?
Truncate: It is a DDL command, used to delete tables or clusters. Since it is a DDL command hence it is auto commit and Rollback can’t be performed. It is faster than delete.
Delete: It is DML command, generally used to delete a record, clusters or tables. Rollback command can be performed, in order to retrieve the earlier deleted things. To make deleted things permanently, “commit” command should be used.

What does dependency analysis mean in Ab Initio?
Dependency analysis will answer the questions regarding data linkage. That is where does the data come from, what applications produce and depend on this data etc. We can retrieve the maximum (surrogate key) from the existing data, the by using the scan or next_in_sequence/reformat we can generate a further sequence for new records.

What is the difference between roll-up and scan?
By using roll-up we cant generate cumulative summary records for that we will be using scan.

How can I run the 2 GUI merge files?
Do you mean by merging Gui map files in WR.If so, by merging GUI map files in GUI map editor it won't create a corresponding test script. without the test script, you can't run a file. So it is impossible to run a file by merging 2 GUI map files.

What methods exist for performance tuning?
The best way would be to perform join at the database, the classical way is when we have two tables that we can bring together by making placing a join component between them. Alternately we can write a query to make the join at the level of a database. The advantage is that only one hit is sent to the database instead of two (the classical method). This makes a real difference in improving performance.

What means writing of wrapper?
Writing of a wrapper will help us run sequential running of two graphs, for instance in order to do this the user must use that feed that was generated by the first graph into the next graph, and for multiple uses into the next graph and so on.

What is the reason for using parameterized graphs?
Their role is seen when we are trying to use the same graph many times for various files, in this way we must set parameters for the graph, which get replaced anyway during the run. So we can keep one graph version for different files and not different versions.

What is API mode versus the utility mode?
Both API and utility modes are used as connection interfaces to the databases for the purpose of performing specific tasks required by the user. They allow us to easily access different functions that the vendor put for use. The role of each function is related to the nature of the databases. The difference between the two modes is that API is known to be slower but offers a higher range of flexibility than the utility mode. Also, API is considered to be a more diagnostic feature.

What is the reason for a database to contain stored procedures?
The main reason is the network traffic reduction. Because stored procedures are precompiled SQL blocks, the time of execution can be reduced. In this way the application performance is higher, being stored in the database the procedure will be called by the application and execute faster than in the case is not already compiled. They also provide reusability for different other applications.

Common Ab Initio Interview Questions and Answers PDF

What is the purpose of the ramp limit?
The limit parameter is representing how much reject events exist and is an integer, while the limit parameter is the rate of reject events that the records processed has, it is a real number.

What is the role of a driving port?
Driving port is usually meant for graph performance enhancement.

What can we say about partitioning with key and round robin?
The partitioning with key (also called hash partition) is the partitioning method used when we have diverse keys. The technique is used basically in the processing of parallel data. On the other hand round, robin partitioning is a technique that allows us to distribute the data on every destination partition uniformly. While in the case of partitioning with the key we can have large data skew due to large key volume, in the case of using round-robin partitioning the skew is zero.

What is the definition of a multistage component?
It is a transform component in which we find different packages.

What are the supported layouts in Ab Initio?
The supported layouts are serial and the parallel and a graph can include them both. The parallel layouts is related to the parallelism degree.

What can we say about the Scan component versus a RollUp component?
Scan components make a total series of records while RollUp components summarize groups of data records.

What is the meaning of a DB config versus a CFG file?
The similarity between these two types is that they are both used for database connectivity. The difference is the usage in Informix Database of the CFG file type and the DB config files are used in SQL Server or Oracle.

How the term Standard Environment can be explained?
The Standard Environment is the type of environment with more than one project that is private and another public one.

How much memory do we need for a graph?
Some calculations lead to approximately eight MB plus the MAX_CORE and the phase file size.

What difference does exist between Checkpoint and Phase?
What phasing does is deleting the intermediate (temporary) files before a new phase begins which is different from checkpointing. The checkpoints keep the temporary files until we finish the graph, so in case of failing, we can restore the last good process. The phase doesn’t have this advantage.

What role has the XFR function?
The purpose of this function is usually to store mappings and this is very useful because the rewriting of code takes time and the XFR spares us of this effort.

What possible errors we can receive from a graph execution?
The compilation errors in Ab Initio can appear when for example the output DML is not as the input DML.

Download PDF Ab Initio Interview Questions with Answers

What is the meaning of EME?
As the initials for Enterprise Meta-Environment EME is a data repository or a version controller in AB Inition. It is capable of doing a lock and keeps track of graphs or other objects.

What meaning has lock-in Ab Initio?
A graph must be locked in order to give permission only to the developer for editing it or the objects that belong to the graph. When other users try to lock the graph they will be warned on the monitor that another user has already made a lock. This is a protection mechanism for developers.

Can a graph be infinitely run? If yes, how?
Yes, it can, by calling the .ksh file at the end of the script.

What is the component that can be used to lower a file in size?
The components that can be used are Deflate and Compress.

Searches related to Ab Initio Interview Questions and Answers

  • ab initio interview questions jp morgan
  • abinitio interview questions accenture
  • abinitio interview questions citi
  • abinitio interview questions capgemini
  • abinitio interview questions cognizant
  • ab initio interview questions ibm
  • abinitio interview questions and answers for pdf free download
  • advanced ab initio interview questions and answers
  • ab initio admin interview questions
  • ab initio administrator interview questions
  • ab initio advanced interview questions
  • abinitio interview questions barclays
  • ab initio basic interview questions
  • barclays abinitio interview questions
  • ab initio bre interview questions
  • best ab initio interview questions
  • ab initio scenario based interview questions
  • ab initio components interview questions
  • ab initio complex interview questions
  • cts abinitio interview questions
  • citibank abinitio interview questions
  • ab initio conduct it interview questions
  • ab initio dqe interview questions
  • senior ab initio developer interview questions
  • etl abinitio interview questions
  • ab initio experience interview questions
  • exusia abinitio interview questions
  • ab initio eme interview questions
  • abinitio interview questions exusia
  • ab initio express it interview questions
  • abinitio interview questions for 2 years experience
  • abinitio interview questions for barclays
  • abinitio interview questions for wells fargo
  • abinitio interview questions for testers
  • abinitio interview questions for freshers
  • abinitio interview questions for 3 years experience
  • abinitio interview questions for beginners
  • ab initio geek interview questions
  • abinitio interview questions geekinterview
  • ab initio gde interview questions
  • greek interview questions ab initio
  • ab initio metadata hub interview questions
  • abinitio interview questions in accenture
  • abinitio interview questions in ibm
  • scenario based interview questions in ab initio
  • ab initio job interview questions
  • jpmc abinitio interview questions
  • latest ab initio interview questions
  • abinitio interview questions latest
  • ab initio lead interview questions
  • abinitio interview mcq questions
  • ab initio metaprogramming interview questions
  • abinitio interview questions on plans
  • abinitio interview questions on normalize
  • ab initio plan interview questions
  • ab initio pdl interview questions
  • ab initio pilot interview questions
  • ab initio production support interview questions
  • ab initio support interview questions
  • abinitio interview questions scenario based
  • syntel abinitio interview questions
  • abinitio interview questions syntel
  • ab initio technical interview questions
  • abinitio interview questions transunion
  • ab initio tough interview questions
  • transunion abinitio interview questions
  • top abinitio interview questions
  • ab initio tool interview questions
  • abinitio interview questions tetrasoft
  • ab initio unix interview questions
  • abinitio unix interview questions
  • latest ab initio interview questions with answers
  • abinitio interview questions wipro
  • abinitio interview questions weebly

Post Top Ad

Your Ad Spot