Category Archives: Ab Initio Interview Questions

What is the relation between EME , GDE and Co-operating system ? | Ab Initio Questions

EME is said as enterprise metdata env, GDE as graphical devlopment env and Co-operating sytem can be said as asbinitio server relation b/w this CO-OP, EME AND GDE is as follows Co operating system is the Abinitio Server.This co-op is … Continue reading

Posted in Ab Initio Interview Questions | Leave a comment

How do you truncate a table? | Ab Initio Questions

From Abinitio run sql component using the DDL “trucate table By using the Truncate table component in Ab Initio.

Posted in Ab Initio Interview Questions | Leave a comment

How do you improve the performance of a graph? | Ab Initio Questions

There are many ways the performance of the graph can be improved: 1) Use a limited number of components in a particular phase 2) Use optimum value of max core values for sort and join components 3) Minimise the number … Continue reading

Posted in Ab Initio Interview Questions | Leave a comment

What is the difference between partitioning with key and round robin? | Ab Initio Questions

Partition by Key or hash partition -> This is a partitioning technique which is used to partition data when the keys are diverse. If the key is present in large volume then there can large data skew. But this method … Continue reading

Posted in Ab Initio Interview Questions | Leave a comment

How do you add default rules in transformer? | Ab Initio Questions

Add Default Rules — Opens the Add Default Rules dialog. Select one of the following: Match Names — Match names: generates a set of rules that copies input fields to output fields with the same name. Use Wildcard (.*) Rule … Continue reading

Posted in Ab Initio Interview Questions | Leave a comment

Have you used rollup component? Describe how. | Ab Initio Questions

If the user wants to group the records on particular field values then rollup is best way to do that. Rollup is a multi-stage transform function and it contains the following mandatory functions. 1. initialise 2. rollup 3. finalise Also … Continue reading

Posted in Ab Initio Interview Questions | Leave a comment

Have you worked with packages? | Ab Initio Questions

Multistage transform components by default uses packages. However user can create his own set of functions in a transfer function and can include this in other transfer functions.

Posted in Ab Initio Interview Questions | Leave a comment

Explain the methods to improve performance of a graph? | Ab Initio Questions

The following are the ways to improve the performance of a graph : – Make sure that a limited number of components are used in a particular phase – Implement the usage of optimum value of max core values for … Continue reading

Posted in Ab Initio Interview Questions | Leave a comment

What is the function that transfers a string into a decimal? | Ab Initio Questions

– Use decimal cast with the size in the transform() function, when the size of the string and decimal is same. – Ex: If the source field is defined as string(8). – The destination is defined as decimal(8) – Let … Continue reading

Posted in Ab Initio Interview Questions | Leave a comment

Describe the Evaluation of Parameters order. | Ab Initio Questions

Following is the order of evaluation: – Host setup script will be executed first – All Common parameters, that is, included , are evaluated – All Sandbox parameters are evaluated – The project script – project-start.ksh is executed – All … Continue reading

Posted in Ab Initio Interview Questions | Comments Off on Describe the Evaluation of Parameters order. | Ab Initio Questions