Ab initio is one of the leading tools that has been used to remove, load, and transform data. This tool has been used by several companies and tech industries so it is quite popular and in-demand right now. So working for such a prestigious company would be a dream come true for aspiring tech-savvy professionals. Now the questions are, what do you have to do to get the job? In our opinion, you have to have a good knowledge of the work that you might do in the company and about everything relevant to the job. For that, they might check your academic background as well as your knowledge and personality in the interview to test whether or not you are good for the job.
Now the interview is not something you wanna take for granted. No matter how good you are, you can always have some doubts or nervousness about the interview. Moreover, if you are one who has never been to such an interview, then you will feel a little bit nervous about the interview. Although any experienced person would be as nervous and intimated as you for the interview.
One of the things that can help you with your upcoming interview is to know what to expect. You might do a little research and find out what kind of questions they can ask you in the interview. That’s the tricky part, after all, how can you know what they will ask you right? Well, you can’t but as we said, it won’t be a loss if you have some idea about what kind of questions they can ask.
So to help you with that, we have happened to have a collection of Ab initio interview questions for you. These questions would certainly help you get some idea about the kind of questions you can expect and how you can answer them. So take a look at the following list of common Ab initio interview questions.
Also check- WCF Interview Questions / Java 8 Interview Questions
Abinitio Interview Questions
Q. What are kinds of layouts does ab initio supports?Basically there are serial and parallel layouts supported by AbInitio. 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.
Q. How do you add default rules in transformer?Double click on the transform parameter of parameter tab page of component properties, it will open transform editor. In the transform editor click on the Edit menu and then select Add Default Rules from the dropdown. It will show two options – 1) Match Names 2) Wildcard.
Q. Do you know what a local lookup is?If your lookup file is a multifile and partioned/sorted on a particular key then local lookup function can be used ahead of lookup function call. This is local to a particular partition depending on the key.Lookup File consists of data records which can be held in main memory. This makes the transform function to retrieve the records much faster than retrieving from disk. It allows the transform component to process the data records of multiple files fast.
Q. What is the diff b/w look-up file and look-up, with a relevant example?Generally, Lookup file represents one or more serial files (Flat files). The amount of data is small enough to be held in the memory. This allows transform functions to retrieve records much more quickly than it could retrieve from Disk.
Q. How many components in your most complicated graph?It depends the type of components you us. Usually avoid using much complicated transform function in a graph.
Q. Have you worked with packages?Multistage transform components by default use packages. However user can create his own set of functions in a transfer function and can include this in other transfer functions.
Q. Can sorting and storing be done through single software or you need different for these approaches?Well, it actually depends on the type and nature of data. Although it is possible to accomplish both these tasks through the same software, many software have their own specialization and it would be good if one adopts such an approach to get the quality outcomes. There are also some pre-defined set of modules and operations that largely matters. If the conditions imposed by them are met, users can perform multiple tasks with the similar software. The output file is provided in the various formats.
Q. What is the relation between eme, gde and co-operating system?Eme is said as enterprise metadataenv, gde as graphical development env and co-operating system can be said as abinitio server relation b/w this co-op, eme and gde is as fallowsco operating system is the abinitio server. This co-op is installed on particular o.s platform that is called native o.s .coming to the eme, its just as repository in Informatica, its hold the metadata, transformations, dbconfig files source and targets information’s. Coming to gde its is end user environment where we can develop the graphs (mapping just like in Informatica) designer uses the gde and designs the graphs and save to the eme or sand box it is at user side. Where eme is at server side.
Q. What are the benefits of data processing according to you?Well, processing of data derives a very large number of benefits. Users can put separate many factors that matters to them. In addition to this, with the help of this approach, one can easily keep up the pace simply by deriving data into different structures from a totally unstructured format. In addition to this, processing is useful in eliminating various bugs that are often associated with the data and cause problems at a later section. It is because of no other reason than this, data processing has wide application in a number of tasks.
Q. What exactly do you understand with the term data processing and businesses can trust this approach?Processing is basically a procedure that simply covert the data from a useless form into a useful one without making a lot of efforts. However, the same may vary depending on factors such as the size of data and its format. A sequence of operations is generally carried out to perform this task and depending on the type of data, this sequence could be automatic or manual. Because in the present scenario, most of the devices that perform this task are PC’s automatic approach is more popular than ever before. Users are free to obtain data in forms such as a table, vectors, images, graphs, charts and so on. This is the best things that business owners can simply enjoy.
Q. How data is processed and what are the fundamentals of this approach?There are certain activities which require the collection of the data and the best thing is processing largely depends on the same in many cases. The fact is data needs to be stored and analyzed before it is actually processed. This task depends on some major factors are they are1. Collection of Data2. Presentation3. Final Outcomes4. Analysis5. SortingThese are also regarded as the basic fundamentals that can be trusted to keep up the pace in this matter.Q. What would be the next step after collecting the data?Once the data is collected, the next important task is to enter it in the concerned machine or system. Well, gone are those days when storage depends on papers. In the present time, data size is very large and it needs to be performed in a reliable manner. The digital approach is a god option for this as it simply let users perform this task easily and in fact without compromising with anything. A large set of operations then need to be performed for the meaningful analysis. In many cases, conversion also largely matters and users are always free to consider the outcomes which best meet their expectations.
Q. What is data encoding?Data needs to be kept confidential in many cases and it can be done through this approach. It simply make sure of information remains in a form which no one else than the sender and the receiver can understand.
Q. What does EDP stand for?It means Electronic Data Processing
Q. Name one method which is generally considered by remote workstation when it comes to processingDistributed processing
Q. What do you mean by a transaction file and how it is different from that of a Sort file?The Transaction file is generally considered to hold input data and that is for the time when a transaction is under process. All the master files can be updated with it simply. Sorting is done to assign a fixed location to the data files on the other hand.
Q. What is the use of aggregation when we have rollupas we know rollup component in abinitio is used to summarize group of data record. Then where we will use aggregation?Aggregation and Rollup both can summarize the data but rollup is much more convenient to use. In order to understand how a particular summarization being rollup is much more explanatory compared to aggregate. Rollup can do some other functionality like input and output filtering of records.Aggregate and rollup perform same action, rollup display intermediate result in main memory, Aggregate does not support intermediate result.
Q. Give one reason when you need to consider multiple data processing?When the required files are not the complete outcomes which are required and need further processing.
Q. What are the types of data processing you are familiar with?The very first one is the manual data approach. In this, the data is generally processed without the dependency on a machine and thus it contains several errors. In the present time, this technique is not generally followed or only a limited data is proceed with this approach. The second type is the Mechanical data processing. The mechanical devices have some important roles in it this approach. When the data is a combination of different formats, this approach is adopted. The next approach is the Electronic data processing which is regarded as fastest and is widely adopted in the current scenario. It has top accuracy and reliability.
Q. Name the different type of processing based on the steps that you know about?They are:1. Real-Time processing2. Multiprocessing3. Time Sharing4. Batch processing5. Adequate Processing
Q. Why do you think data processing is important?The fact is data is generally collected from different sources. Thus, the same may vary largely in a number of terms. The fact is this data needs to be passed from various analysis and other processes before it is stored. This process is not as easy as it seems in most of the cases. Thus, processing matter. A lot o time can be saved by processing the data to accomplish various tasks that largely matters. The dependency on the various factors for the reliable operation can also be avoided by to a good extent.
Q. What is common among data validity and Data Integrity?Both these approaches deal with errors related with errors and make sure of smooth flow of operations that largely matters.
Q. What do you mean by the term data warehousing? Is it different from Data Mining?Many times there is a need to have data retrieval, warehousing can simply be considered to assure the same without affecting the efficiency of operational systems. It simply supports decision support and always works in addition to the business applications and Customer Relationship Management and warehouse architecture. Data mining is closely related to this approach. It assures simple findings of required operators from the warehouse.
Q. What exactly do you know about the typical data analysis?It generally involves the organization as well as the collection of important files in the form of important files. The main aim is to know the exact relation among the industrial data or the full data and the one which is analyzed. Some experts also call it as one of the best available approaches to find errors. It entails the ability to spot problems and enable the operator to find out root causes of the errors.
Conclusion –So these are the Ab initio interview questions that are commonly asked the candidates. These questions have been picked by some professionals and experts to help freshers as well as experienced candidates for Ab initio job. We are not saying that these would be the only questions that would be asked in the interview, but we can say that these are generic questions, and the interviewers might ask them as well. Overall your chance of getting the job would be enhanced if you prepare these questions for your upcoming interview. Thank you and Good Luck!