-
Order of Graph Execution
What is the order of execution of a graph when it runs?
Divya Sama
- Dec 14th, 2009
1. Initialisation of Parameters2. Start script execution3. Graph execution4. End script execution
shivhare.pankaj
- Nov 17th, 2009
1. All its parameters are initialized2. Start script call3. Graph start4. End script executed.
-
Parametrization of MFS
I want to use an Ab Initio parameter to control whether I am in serial or MFS mode. Basically, I will have an $AI_MFS_PARTS variable. If it is set to 1, then we are running serial. If it is set to 4, then we are running 4-way MFS. Will the data need to be located in physically different locations using different control files?
sixto.dsilva
- Dec 6th, 2009
I think we can have two parameters like AI_SERIAL and AI_MFS to determine where we are in serial location or MFS location. This is best way of finding out whether the file is serial or MFS. Hope this help.
abhi_fresh_as_dew
- Dec 11th, 2008
Its always better to use multiple file system instead of adhoc multifiles.So,physical allocation is a good idea for separation of mfs and serial.Say,i have a physical allocation to path1 for mfs and h...
-
what is the function of XFR in abinitio
It would be great if one of you can explain me in brief what is the function of xfr (like what does it do ,where is it stored ,how does it affect ) as i am very confused on thisthank you
Shireesh
- Nov 14th, 2009
XFR is used for externalizing a transform/function. A function which needs to be reused at multiple places can be created as a common XFR instead of writing the same code again and again.
smarty.malik
- Dec 10th, 2008
The XFR usually stores the mappings in the text view. Usually these mappings are generalised. In the Transformation of any component these XFR's can be called and abi nitio will automatically do the s...
-
What is wrapper script in Ab initio
anujaja
- Aug 25th, 2009
When you deploy an Ab Initio graph it becomes a ksh script saved in Run directory.Wrapper is another Unix script which calls the above mentioned deployed script.It might also be use to handle other functionalities together with execution of graph.
Sabitra S Panda
- Dec 10th, 2008
Wrapper script is an Unix script, which is helpful in running the graphs directly through Unix and running it automatically. This is useful when we have Unix as the operating system.
-
Sort within Group
What is the advantage of SORT within GROUP Clause?
veerahkvr
- Aug 22nd, 2009
Sort within Groups refines the sorting of data records already sorted according to one key and it sorts the records within the groups formed by the first sort according to a second key.
-
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;
-
Abinitio MFS
There is one MF while loading data i deleted one partition in a MF? Can it show error/it will process data?
sixto.dsilva
- Jul 25th, 2009
yes the above point is also valid , if file does not exist , the ab initio will throw an error. If it is truncated ,you will loose the data but abinitio will not throw an error.
njvijay
- May 11th, 2008
Did you delete data in partition or deleted partition itself?If data is deleted (or truncated) in a partition, ab-initio does not throw the error.If a partition itself is deleted, ab-initio is going to throw the error.
-
Describe which system/process elements you would review when trouble-shooting general server slowness.
-
What is the name of the SQL language used in SQL Server stored procedures?
-
What is the lookup function used to retrieve the particular duplictae datarecords in the lookup file
abhi_fresh_as_dew
- Jun 29th, 2009
Use lookup_count for finding the duplicates and lookup_next for retrieving it.If lookup_count (string file_label, [ expression [ , expression ... ] ] )>0lookup_next ( lookup_identifier_type lookup_id, string lookup_template ) Njoi!!Abhi - fresh as dew!
pradeep
- Nov 16th, 2006
Lookup_next function is used for retrieving duplicates records of that particular record
-
What is the difference between the flows of 3 parallelisms
sixto.dsilva
- Jun 22nd, 2009
I think i misunderstood the question ,there are 3 type of parallelisms in Ab Initio , details of 3 types are expalined correctly above with difference.
ravula sudheer
- Oct 18th, 2008
ab initio supports parallilesm..parallilesm 3 types 1.component parallilasem: graph running the data sumaltenously on seperate data uses. every component graph creates one component process ..this is ...
-
In a process which reads 15,000 rows from one table and either updates or inserts them into another table and given the scenario where the process may abnormally terminate, describe how you track progress within the data to ensure the process could be restarted without repeating any processing.
PeeD1
- Apr 17th, 2009
The following are some possible strategies for dealing with this problem: 1) If a job does a bulk load into a table and you know the table was empty before the job began, you can truncate the table be...
-
What are Cartesian joins?
PeeD1
- Apr 16th, 2009
When there are duplicate keys in either or all of the joined datasets the result is a cartesion product. This is termed as Cartesian Join in Abinitio.Eg:If there are two input datasets for a join func...
-
Abinitio Environment Variables
What are environment variable? Why are they required?
annegrace1
- Apr 8th, 2009
Environment Variables or other wise know as ABINITIO environment variable. Its set in stdenv under which private project and pubic project will be there.Parameters like $AB_HOME , $AB_AIR_RROT will be present in environment variable and this will link to the relational path respectively
-
Input Table component layout - Abinitio
My question is related to the INPUT TABLE component layout. If we select the layout to be DATABASE- (database default), where exactly is it pulling that layout from? When should this option be used? Within the DATABASE layout we also see the SERIAL ,TABLE and EXPLICIT args options, when do we use those? what are the advantages and disadvantages to this approach? Thanks
annegrace1
- Apr 8th, 2009
I would suggest you not to use the default database. either ai_serial or ai_mfs.Default database will pick the data from the database in the same structure as it is in db.The data in db might be serial or partition.
ankithak
- Oct 13th, 2007
Hi mahindra , I didnt get ur answer .If u dont mind pls give me clear explanation with example.
-
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?
-
Ab_job Command
What is use of Ab_job command in Abinitio?
annegrace1
- Apr 6th, 2009
When you want to run the same instance of the graph many times which is palced in one place then we go for AB_JOB. its should be defined in sandbox parameter. If you dont give the value for it it will take AB_JOB as default
er_jyoti028
- Nov 27th, 2008
AB_JOB parameter is set when we want to run the same graph at the same time for different job names.
-
How to run the graph without GDE?
amitesh87
- Apr 2nd, 2009
From UNIX you can go to pset folder in your sandbox then type??air sandbox run abc.pset Whatever may be your psets name or just call graph script .ksh
mahendra patnaik
- Feb 5th, 2007
Hi,it is possible in Unix... first you have to go to the directory where your deployed script is saved for that particular graph then execute the shell script by using the following command.../.kshI hope it will help you ...regards,Mahendra
-
One of the performance tuning techiques is join with database kept to a minimum. why?
Subhra Dhar
- Mar 26th, 2009
Join with Database (Join with DB) should not be used if number of records to be?joined with a table is very high as it degrades?performance. Better result can be achieved by retrieving the data from...
K Vijay Kumar
- Oct 28th, 2006
Performing join at database will improve the performance a lot.take a scenario of joining between the two tables. Usally we take two database components and place a join component to perform a join be...
-
How might you quantitatively measure an improvement made to a query?
Subhra Dhar
- Mar 25th, 2009
By checking the execution plan of the query after doing each modification and determining the cost of the query.
Abinitio Interview Questions
Ans