CoolInterview.com - 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
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS ABINITIO INTERVIEW QUESTIONS 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?

Answer:
Question: What is m_dump



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

m_dump <dml> <file.dat>
Source: CoolInterview.com
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.

Source: CoolInterview.com
Question: What is the difference between partitioning with key and round robin?

Answer: PARTITION BY KEY:

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.



PARTITION BY ROUND ROBIN:

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: CoolInterview.com
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: CoolInterview.com
Question: Have you eveer encountered an error called 'depth not equal'? (This occurs when you extensively create graphs it is a trick question)

Answer: When two components are linked together if their layout doesnot match then this problem can occur during the compilation of the graph. A solution to this problem would be to use a partitioning component in between if there was change in layout. Source: CoolInterview.com
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 in.you 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: CoolInterview.com
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 (ccev56@nus.edu.sg) Source: CoolInterview.com
Question: What is the syntax of m_dump command?



Answer: The genaral syntax is "m_dump metadata data [action] "
Source: CoolInterview.com
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.

Source: CoolInterview.com
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.
Source: CoolInterview.com
Question: How can we test the abintio manually and automation?



Answer: i hope abinitio testing is to be carried manually only no automation is available as of now.we need to integrate the graphs n also run them manually n carry on the process.thats it.
Source: CoolInterview.com
Question: How to get DML using Utilities in UNIX?



Answer: If your source is a cobol copybook, then we have a command in unix which generates the required in Ab Initio. here it is:

cobol-to-dml.
Source: CoolInterview.com
Question: How to take the input data from an excel sheet?



Answer: There is a Read Excell component that reads the excel either from host or from local drive.The dml will be a default one.

Source: CoolInterview.com
Question: What is skew and skew measurement?



Answer: skew is the mesaureof data flow to each partation .

suppose i/p is comming from 4 files and size is 1 gb

1 gb= ( 100mb+200mb+300mb+5oomb)

1000mb/4= 250 mb

(100- 250 )/500= --> -150/500 == cal ur self it wil come in -ve value.

calclu for 200,500,300.

+ve value of skew is allways desriable.

skew is a indericet measure of graph.

Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: What is the relation between EME , GDE and Co-operating system ?




Answer: 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 fallows

Co operating system is the Abinitio Server. this co-op is installed on perticular O.S platform that is called NATIVE O.S .comming to the EME, its i just as repository in informatica , its hold the metadata,trnsformations,db config files source and targets informations. comming to GDE its is end user envi Source: CoolInterview.com
Question: Can anyone give me an exaple of realtime start script in the graph?



Answer: Here is a simple example to use a start script in a graph:

In start script lets give as:

export $DT=`date '+%m%d%y'`

Now this variable DT will have today's date before the graph is run.

Now somewhere in the graph transform we can use this variable as;

out.process_dt::$DT;

which provides the value from the shell.

Source: CoolInterview.com
Question: What are kinds of layouts does ab initio supports



Answer: 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. Source: CoolInterview.com

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.578125 Seconds