Ab Initio Interview Questions asked in top companies.
Explain what is the relation between GDE, EME and Co-operating system in ABI?Answer : EME is an enterprise metadata environment GDE as graphical development environment Co-operating system can be said as Ab Initio Server.
The relation between Co-operating system, EME and GDE is as cited below.
Co operating system is the Ab Initio Server.This Co-operating is installed on particular Operation System platform which is called Native OS. EME is just as repository in Informatica , it hold the metadata information, transformations, database configuration files, source and target information. GDE is end user environment where we can develop the graphs. Designer uses the GDE and designs the graphs and save to the EME or Sandbox at the user side where EME is at the server side.
Explain the different kinds of layouts that Ab Initio supports?
Answer : There are serial and parallel layouts supported by Ab Initio. A graph can have both at the same time. The parallel one depends on the degree of data parallelism. If the multi-file system is 4-way parallel then a component in a graph can run 4 way parallel if the layout is defined such as it's same as the degree of parallelism.
Explain the process of adding default rules in transformer?
Answer : You need to do the following steps. Double click on the transform parameter of parameter tab page of component properties, which will open transform editor for the user. While in the transform editor, click on the Edit menu and select Add Default Rules from the drop-down menu. It will show up two options
Match Names and Wildcard.
Explain the process of running a graph infinitely in Ab Inito?
Answer : In order to run a graph infinitely in Ab Initio, the end script in the graph should be calling the .ksh file of the graph. Hence, if the name of the graph is abc.mp then in the end script of the graph, there should be a call to abc.ksh. In this way we can make the graph will run infinitely.
Explain in detail with an example what is the difference between look-up file and look-up?
Answer : Look-up file represents one or more serial files(Flat files). The amount of data is small enough to be held within the memory. This allows transform functions to retrieve records much more quickly than it could retrieve from Disk.
A look-up is a component of the Ab Initio graph where we can store data and retrieve it by using a key parameter.A look-up file is the physical file in the disk where the data for the look-up is stored.
Explain what is the function of look-up?
Answer : Look-up is a specific data-set which is keyed. It can be used to mapping values as per the data present in a particular file (serial/multi file). The data-set can be static as well as dynamic. Sometimes, hash-joins can be replaced by using reformat and look-up if one of the input to the join contains less number of records with slim record length. AbInitio has defined some built-in functions to retrieve values using the key for the look-up
What do you mean by a local look-up in Ab Initio?
Answer : If your look-up file is a multi-file and partitioned/sorted on a particular key, then local look-up function can be used ahead of look-up function call. This is local to a particular partition depending on the key.
Look-up File consists of data records which can be held in the main memory. This will make the transform function to retrieve the records much much faster than retrieving from the disk. It also allows the transform component to process the data records of multiple files in a faster way.
- Check all Ab Initio Interview Question and Answers Here
Related Posts
No comments :