-
Do you know what a local lookup is?
mukund
- Dec 26th, 2006
Hi,lookup_local funtion retrieves the first matching record from a partitioned multifile,which is partitioned on a particular key.consider a lookup file "emp_detail" which is having the fields emp_id,...
vpnreddy
- Nov 7th, 2005
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 retirving from disk. It allows the transform component to process the data records of multiple files fastly.VPN Reddy
-
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 the difference between a Scan component and a RollUp component?
DilipPanda
- Apr 4th, 2010
Finalize function of SCAN Component is called for each record for a group where as for rollup component it called only once.
satish kumar
- Apr 23rd, 2006
Roll up generates data records that summarizes group of data records the rollup can be used to perform the data aggregatuin like sum,avg,max,min etcScan component generates a series of cumulative summary records such as successive yera to date totals for group of data records
-
What is semi-join
jagan
- Nov 16th, 2011
A semi-join returns rows from one table that would join with another table without performing a complete join. It doesn't have explicit syntax. Eg : semi join to evaluate an exists sub query {gesh...
prabhupurna
- Jul 6th, 2006
in abinitio,there are 3 types of join...1.inner join. 2.outer join and 3.semi join.for inner join 'record...
-
-
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...
-
-
-
-
How to use max core number of rows?
mukund
- Dec 22nd, 2006
Hi,max-core is very essential parameter in componets like sort,rollup,scan etcmax-core gives the amount of momory which a component uses to process data before spilling to disk ie we need to have an o...
sekhu_da
- Nov 15th, 2006
Most of the time you will not touch the max core value ! even though some one ask in interview strght way say most of the time we use default value.
-
Records Filter
How to filter the records by using Reformat?
sham2sushil
- Oct 23rd, 2010
We can also use the Reformat feature output_index and output_indexes. If you have more filter condition then increase the no of count and use the if else condition with the Priority assignment. ...
-
What command would you use to inspect the users currently logged into SQL Server database?
titli_n_titli
- Aug 14th, 2009
The below SQL Query can solve the purpose:select username from V$SESSION;
-
What is Vector Field? Explain.
arpit mathur
- Sep 29th, 2011
Hi Can u please explain it with example, i need to build the vector for comparison of the inputs records , if that records matches then i take the output
annegrace1
- Apr 8th, 2009
Vector field is like an array which is used in C/C++.Its mainly used in normalize and denormalize component.
-
What are the different schedulers used for running the abinitio graphs
abhi_fresh_as_dew
- Sep 8th, 2008
You can do anything in Ab Initio, depends on the logic you useSay there are 10 jobs 1,2,3,4,5 .. 10 and all the graphs are deployed as script.Suppose 1-4 graps should run at the same time and sequenti...
sreenivasamurthy
- Jun 19th, 2007
In ab initio there are no specific scheduling options as in informatica. What we can do is use cronjob options as in unix
-
What is EME?
sixto.dsilva
- Aug 1st, 2008
As explained by Abishek, EME is the data repository(Datastore's data files)?as well a version controller compoent of ab initio software. It keeps track of obhects such as graph, dml, xfr, ksh and sq...
sreenivasamurthy
- Jun 20th, 2007
EME stands for Enterprise Meta Environment. It is nothing but like a repository in Informatica. It contains all the metadata i.e data related to graphs, dml, xfr, etc. It performs the following func...
-
How to handle if DML changes dynamically in abinitio
annegrace1
- Apr 6th, 2009
Give the parameters using edit parameter and make it as formal parameter that is run time parameter.Then in the DML eg. $AI_DML/abc_$parameter1.dmlAccording to the value of the parameter that particular DML will be called.
Guru
- Sep 4th, 2007
If DML changes dynamically in source we can handle it using "Conditional DML'But how it can be achieved in "parameterisation" and using "metadata". Please explain?
-
How to take the input data from an excel sheet?
N MAHAMMAD RAFI
- Nov 24th, 2006
Hi GUYS, COMPONENTS>TRANSALATE>READ SAPARATED VALUES component ... U CAN USE THIS EXCEL FOR EXCEL SHEET...................THANKSRAFI CHENNAI
-
How Does MAXCORE works?
prabhupurna
- Jul 8th, 2006
Every component in Ab initio has a memory of 7MB (anybody correct me if I'm wrong) except a few components like In-Memory components such as join, Rollup, Scan, join with DB etc., which uses an a...
atish_ban
- Apr 2nd, 2006
It is maximum temporary scratchpad memory allowed for execution of a in-memory component/per partition.
-
Hi !I have worked on datastage and informatica ..we have option called report where we can generate the complete job ryt from components to code ..i want know ab-initio does it have facility of job report.
kalyanvadlamudi2kn
- Jan 10th, 2014
There are a lot of options in Ab Initio. To get the report at Component level,Graph level ( Log port, AI_SUMMARY files). Ab Initio can even generate reports at the transformation level how many times ...
know_know
- Feb 21st, 2011
There is a log port in every component available. You can use this port to generate reports.
Abinitio Interview Questions
Ans