- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Abinitio Interview Questions & Answers - Learning Mode

Abinitio Interview Questions & Answers - Learning Mode

The Ab Initio software is a fourth generation data analysis, batch processing, data manipulation graphical user interface (GUI)-based parallel processing tool which is commonly used to extract, transform and load data.

Try Abinitio Interview Questions & Answers - Exam Mode

1 2 3 4 5 6 Next

Sort By : Latest First | Oldest First | By Rating

Abinitio Interview Questions & Answers - Learning Mode
Try Abinitio Interview Questions & Answers - Exam Mode
Question: How do you connect EME to Abinitio Server?

Question: What is m_dump

Answer: m_dump command prints the data in a formatted way.

m_dump <dml> <file.dat>
Question: How many parallelisms are in Abinitio? Please give a definition of each.


There are 3 types of parallelism in ab-initio.

1) Data Parallelism: Data is processed at the different servers at the same time.

2) Pipeline parallelism: In this the records are processed in pipeline, i.e. the components do not have to wait for all the records to be processed. The records that got processed are passed to next component in pipeline.

3) Component Parallelism: In this two or more components process the records in Source:
Question: Why might you create a stored procedure with the 'with recompile' option?

Answer: Recompile is useful when the tables referenced by the stored proc undergoes a lot of modification/deletion/addition of data. Due to the heavy modification activity the execute plan becomes outdated and hence the stored proc performance goes down. If we create the stored proc with recompile option, the sql server wont cache a plan for this stored proc and it will be recompiled every time it is run. Source:
Question: What does dependency analysis mean in Ab Initio?

Answer: Dependency analysis will answer the questions regarding datalinage.that is where does the data come from,what applications prodeuce and depend on this data etc.. Source:
Question: How to Create Surrogate Key using Ab Initio?

Answer: There r many ways to create Surrogatekey but it depends on your business logic. here u can try these ways...

1. use next_in_sequence() function in your transform.

2.use Assign key values component (if ur gde is higher than 1.10)

3.write a stored proc to this and call this stor proc wherever u need

Question: What is data mapping and data modelling?

Answer: data mapping deals with the transformation of the extracted data at FIELD level i.e. the transformation of the source field to target field is specified by the mapping defined on the target field. The data mapping is specified during the cleansing of the data to be loaded.

For Example:


string(35) name = "Siva Krishna ";


string("01") nm=NULL("");/*(maximum length is string(35))*/

Then we can have a mapping like:

Straight move.T Source:
Question: What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox/ Can anybody explain checkin and checkout?

Answer: Sandboxes are work areas used to develop, test or run code associated with a given project. Only one version of the code can be held within the sandbox at any time.
The EME Datastore contains all versions of the code that have been checked into it. A particular sandbox is associated with only one Project where as a Project can be checked out to a number of sandboxes Source:
Question: Can we load multiple files?

Answer: Load multiple files from my perspective means writing into more than one file at a time. If this is the same case with you, Ab initio provides a component called Write Multiplefiles (in dataset Component group) which can write multiple files at a time. But the files which are to be written must be local files i.e., they should reside in your local PC. For more information on this component read in help file.

Question: How would you do performance tuning for already built graph ? Can you let me know some examples?

Answer: example :- suppose sort is used in fornt of merge component its no use of using sort ! bcz we hv sort component built in merge.

2) we use lookup instead of JOIN,Merge Componenet.

3) suppose we wnt to join the data comming from 2 files and we dnt wnt dupliates we will use union funtion instead of adding addtional component for duplicate remover.

Question: What is driving port? When do you use it?

Answer: When you set the sorted-input parameter of "JOIN" component to "In memory: Input need not be sorted", you can find the driving port.
Generally driving port use to improve performance in a graph.

The driving input is the largest input. All other inputs are read into memory.

For example, suppose the largest input to be joined is on the in1 port. Specify a port number of 1 as the value of the driving parameter. The component reads all other inputs to the join ? for example, in0, Source:
Question: What do you mean by .profile in Abinitio and what does it contains?

Answer: .profile is a file which gets executed automatically when that particular user logging in.

you can change your .profile file to include any commands that you want to execute whenever u logging can even put commands in your .profile file that overrides settings made in /etc/profile(this file is set up by the system adminiastrator).

you can set the following in your .profile......

- Environment settings

- aliases

- path variables

- name and size of Source:
Question: What is the purpose of having stored procedures in a database?

Answer: Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.
Question: What are local and formal parameter?

Answer: Two are graph level parameters but in local you need to initialize the value at the time of declaration where as global no need to initialize the data it will promt at the time of running the graph for that parameter.<br> Source:
Question: How to run the graph without GDE?

Answer: In RUN ==> Deploy >> As script , it create a .bat file at ur host directory ,and then run .bat file from Command prompt
Question: What is .abinitiorc and What it contain?

Answer: .abinitiorc is the config file for ab initio. It is found in user's home directory. Generally it is used to contain abinitio home path, different log in information like id encrypted password login method for hosts where the graph connects in time of execution.

It may contain inf like EME host and others.
Question: How to work with parameterized graphs?

Answer: One of the main purpose of the parameterized graphs is that if we need to run the same graph for n number of times for different files, we set up the graph parameters like $INPUT_FILE, $OUTPUT_FILE etc and we supply the values for these in the Edit>parameters.These parameters are substituted during the run time. we can set different types of parameters like positional, keyword, local etc.

The idea here is, instead of maintaining different versions of the same graph, we can maintain one Source:
Question: What is the difference between partitioning with key and round robin?


In this, we have to specify the key based on which the partition will occur. Since it is key based it results in very well balanced data. It is useful for key dependent parallelism.


In this, the records are partitioned in sequential way, distributing data evenly in blocksize chunks across the output partition. It is not key based and results in well balanced data especially w Source:
Question: How do you truncate a table? (Each candidate would say only 1 of the several ways to do this.)

Answer: There are many ways to do it.
1. Probably the easiest way is to use Truncate Table
2. Run Sql or update table can be used to do the same thing
3. Run Program

Submitted by Kalyan Samaddar ( Source:
Question: What is the difference between a Scan component and a RollUp component?

Answer: Rollup is for group by and Scan is for successive total. Basically, when we need to produce summary then we use scan. Rollup is used to aggregate data. Source:

1 2 3 4 5 6 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.03125 Seconds