-
Memory requirement of graph
How can I calculate the total memory requirement of a graph?
robmuza
- Jul 10th, 2008
When we did some benchmarking we found that it was closer to ~8MB + MAX_CORE (if any) per component and add in the file sizes.Basically, I agree with the existing answer.Just remember, don't use &...
dhanoo_p
- Jun 23rd, 2008
You can roughly calculate memory requirement as:1. Each partition of a component uses: ~ 7 MB + max-core (if any) 2. Add size of lookup files used in phase (if multiple compon...
-
Have you used rollup component? Describe how.
sixto.dsilva
- Jul 3rd, 2008
Rollup summarises the group of data records based on key eg you want the income of a particular city from a set of records , you can use the rollup component.example dml ...
sangee
- Nov 29th, 2006
Rollup summarize the group of data records.for eg: if we want the maximum value of the cust_id we will go for rollup.
-
How to rerun a graph in UNIX
Mathi777
- Jul 3rd, 2008
When ever a graph fails it creates a .rec file in the working directory ,the directory may be where ur graph deployed script is stored .so remove that .rec file an dthen run the deployed script of the graph from unix,u may use m_rollback -d
sixto.dsilva
- Jun 25th, 2008
You can run the graph by giving the following command in unix dtm run <recvory file name> -continue
-
Abinitio Password
In production also do they will give same password which was given in .DBC?
sixto.dsilva
- Jul 3rd, 2008
Best way is using the environment variable to set the values in dbc file. By this you can have the flexibility to change any variable value's by changing the evironment variable.
njvijay
- May 11th, 2008
Good way doing this is, parameterize .dbc file. Parameter will have different values for different environment.
-
How do you pass parameters to a graph in AI ?
sixto.dsilva
- Jun 25th, 2008
Yes you can declare parametes in edit paramter option in GDE, while running the ksh you can pass the value in command line.
High5
- Feb 16th, 2008
If you want to pass a parameter to your graph then declare a formal parameter in edit-parametrs region.
-
What is the difference between sandbox and EME, can we perform checkin and checkout through sandbox/ Can anybody explain checkin and checkout?thanks advsatish kumar
lakshmipavany.g
- Jun 25th, 2008
Hi EME is like All-In one guide, where as Sand box is an idividual subjected guide restricted for individual user.Check in/ check out are the procedure to send/extract graphs from sandbox to EME....
sivakrishna
- Jul 6th, 2006
The project is under source control under EME. You can't do any manipulations on the project which is in EME. So if you want to do any manipulations you have to check out the project into your sandbo...
-
What are the most commonly used components in a Abinition graph?can anybody give me a practical example of a trasformation of data, say customer data in a credit card company into meaningful output based on business rules?ThanksSri
mukund
- Dec 7th, 2006
Hi gayathri, We cannot say strightly that only certain componets only we have to use,it depends on business requirement,functionality. most frequently we use FBE,REFORMAT,ROLLUP,LOOKUP(LOOKUP_LO...
-
What is data skew? how can you eliminate data skew while i am using partitiion by key?
hsevna
- May 15th, 2008
The skew of a data or flow partition is the amount by which its size deviates from the average partition size, expressed as a percentage of the largest partition:Skew of data =(partition size - avg.partition size)*100/(size of largest partition)
dontbuckme
- Sep 22nd, 2006
data not evenly partitioned. PBE uses hash function. choose the key that has the most distinct values might improve the data being distributed evenly.
-
What is the DBCC command used for?
babuKishore
- Dec 1st, 2006
These statements check the physical and logical consistency of a database. Many DBCC statements can fix detected problems.
-
What is the Difference between DML Expression and XFR Expression ?
sixto.dsilva
- Apr 21st, 2008
DML are record format files used by the metadata files in Ab inition. DML can be embedded in the graph or can be a separate file with .dml extension.xfr file are transform functions used by graph.These are present in sandbox.xfr file can used to manipulate data nad compute new data from it.
K Nagi Reddy
- May 4th, 2006
DML describes the record format of the data. It is metadata.XFR is the set of business rules called a transform function.
-
What is a ramp limit?
sixto.dsilva
- Apr 21st, 2008
Limit parameter contain an interger that represents a number of reject eventsthe ramp parameter contains a real number that represents a rate of reject events in the number of records processed.
sangee
- Nov 29th, 2006
We will go for ramp limit to set the reject threshold for the record being processed.
-
Explain about Multi update in Abinitio and specific business reason for it's use.
sixto.dsilva
- Apr 18th, 2008
multi update executes SQL statmts against incoing records to modify one or more tables in a database.It treatss each input record as a completely separate piece of work.
-
Give examples for pipeline, component and data parallesim?
sixto.dsilva
- Apr 18th, 2008
pipeline Parallelism occurs when the several connected progrm components on the same branch of graph executes simultanteously. if you are using a sort component the pipeline parallelism does not occur...
-
Explain about deadlock in Abinitio
sixto.dsilva
- Apr 17th, 2008
As explained in above answer that when two or more processes are requesting for one singel resource , that time deadlock can occur.in Ab initio deadlock is avoided by using phasing and also by using the resource pool.
varma
- Nov 22nd, 2007
When 2 or more processors are requested for the one single processor, that time deadlock situvation is occured.
-
Standard Environment
What is Standarad Environment? What it contains?
sixto.dsilva
- Apr 17th, 2008
standard environment is the ab initio environment that has more then one private project and also other public project , in addition to the required environment project.Private project is one which no...
surabhiraghu
- Jan 2nd, 2008
std env is nothing but collection of public & private & environment project.
-
Abinitio Partitions
What is the difference between partition, re-partition and departition?
sixto.dsilva
- Apr 15th, 2008
Partition is coverting a serial file(mfs) into multiple flows --> component used is partition by key or partition by round robin.departition is opposite of partition , sometime after the parallel processing , you want output to be serialized we using gather and merge component for this.
rcoon7
- Mar 10th, 2008
Dividing a single flow of records(data) into multiple flows is known as partitioning.Dividing a x-way flows of records(data) into y-way flows is known as re-partitioning.e.g: 2 ways flow ino 4 ways flowCombining multiple flows into a single flow of records(data) is known as departitioning.
-
Abinitio Bad-Straight-flow
When did we get error like 'Bad-Straight-flow'?
sixto.dsilva
- Apr 15th, 2008
It is error you get when there is mismatch in flow that is one is serial flow and other componet is mfs flow , the ab initio will complain about the bad flow and graph is will be aborted because of this. you should be using the partition component in order to avoid this.
rcoon7
- Mar 10th, 2008
Layouts problems in components. e.g. a straight flow connecting a component which is having serial layout with a component which is in muti-file layout.
-
How dynamic DML is created and in which context it is used?
rcoon7
- Mar 10th, 2008
dynamic DML is used if the input metadata can change i.e. suppose at different time different input files are recieved for processing which have different dml.in that case we can use flag in the dml a...
-
Abinitio Air-Project Parameters
What are air-project parameters and air-sandbox? What does it contains?
sixto.dsilva
- Mar 4th, 2008
as we know a sandbox is filesystem which contains all the graphs and other file that graphs depend on. when sandbox contents are put under sourc control in EME datastore it becomes project. Now sanbox...
-
How can you run a graph infinitely?
To run a graph infinitely, the end script in the graph should call the .ksh file of the graph. Thus 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. Like this the graph will run infinitely.
Sai
- Jun 29th, 2006
I wonder why u require this Infinite loop concept if so how to get out if a graph runs recursively..
Abinitio Interview Questions
Ans