-
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 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
-
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.
-
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...
-
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...
-
What is main path and structure of abinitio?
sixto.dsilva
- Aug 15th, 2008
Main paths in Ab initio environment are AB_HOME , specifiec the directory where the co>operating system is installed. This need only be set for those hosts for which the installation directory is diff...
sixto.dsilva
- Apr 17th, 2008
I think the main thing in above is AB_HOME , AB_AIR_ROOT , then sandboxes , standard environment. you need to be specific as what you want in this question.
-
Under what circumstances join should be used instead on lookup.
biyyanimv
- Sep 2nd, 2008
If you have to perform full outer join then you should go for join not for lookup.
sixto.dsilva
- Apr 17th, 2008
Lookup should be used only to speedup the graph execution but here there is catch if the lookup file is small then only we should used lookup because when the graph start executing it will load whole ...
-
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
-
Ab Initio Interview questions compiled. Someone please answer them. It will help all of us here.1) What is the difference between dbc and cfg? When do you use these two?2) What are the compilation errors you came across while executing your graphs?3) What is depth_error?4) During the execution of graph, let us say you lost the network connection, would you have to start the process all over again or does it start from where it stopped?5) Types of partitions and scenarios.6) What does unused port in join component do?7) Define Multi file system. Can you create multifile system on the same server? Also, if you have a table that has Name, Address, Status, Position attributes, can Name and Address be on one partition and Status and Position in the other partition?8) What is a sandbox? Did the co-operating system version 2.8 have sandbox, if not how would you store the respective files?9) How did you do version control? Which tool did you use?10) How do you troubleshoot performance issues in graph?11) What are the usual errors that you encounter during ETL process apart from compilation process?12) Were you involved in production support? What were the different kinds of problems that you encountered?13) Please give us insight on Enterprise Meta Environment, and some possible questions on that.14) What are delta table and master table?15) What error would you get when you use Partition by Round Robin and Join?16) In which scenarios would you use Partition by Key and also, Partition by Round Robin and differences between the both?17) What are the different dimension tables that you used and some columns in the fact table?18) How do you count the number of records in a flat file?19) How do you count the number of records in a multifile system without using GDE?20) What does Scan and Rollup component do and give a scenario where you used them?21) Did you ever used user defined functions or packages? If yes, give a scenario.22) What do you have to give the value for the Record Required parameter for a natural join?23) When do you use Partition by Expression?24) What is Adhoc File System? Give me a scenario where you used it.25) What are the different commands that you used when writing wrappers?26) What do the hidden files in a sandbox represent and what does start.ksh represent?27) What are different things that you have to consider when loading data into a table?28) What is difference between Redefine Format and Reformat components? 29) Sometimes you have to use dynamic length strings. Can you give me one circumstance where you need it?30) If you have a flat file as follows:20 General Manager Chris30 Divisional Manager Harry20 General Manager Mary30 Divisional Manager DravidHow do you count the number of records that have 20 in the first column, and likewise for 30.
ravula sudheer
- Nov 7th, 2008
I am sending some answers which I know. Hope this is helpful to you ..1 a) cfg is the databse table configuration file ,dbc is the data base configuration file. 2.1 databsae component have the ...
-
Indexes in Abinitio
In Abinitio which type of indexes used?
Sabitra S Panda
- Dec 10th, 2008
There is as such no concept of indexing in Ab Initio, since it is a code based ETL tool. Indexes come into picture on the database table side. But there is something called "output indexing" in Ab Ini...
sixto.dsilva
- Apr 15th, 2008
I think we don't have any concept of indexes in ab inition , it is there only in Database like table indexing to improve query performance of the tables.In Ab initio it is only massive parallel processing concept.
-
Abinitio Merge Graphs
How do we merge graphs in AbInitio?
abhi_fresh_as_dew
- Dec 11th, 2008
Get on using .plan in Abinitio in which we can encapsulate different graphs.Abhisek Bfresh as dew!!
Sabitra S Panda
- Dec 10th, 2008
Any graph in ab initio is a separate and independent entity in itself. First of all, there is no such concept of graph merging in ab initio, since it does not make any sense, and two graphs that are s...
-
Ab Initio .mfctl and .mdir Files usage
What is the usage of .mfctl and .mdir files in the mfs directory of Ab Initio?
biyyanimv
- Mar 8th, 2009
.mfctl and .mdir are both related to multifile system. .mfctl extension of control file created when we are using the MFS. The file extension .mfctl will contain the URLs of all the data partitions. The file with the extension .mdir will contain the URL of the control file used by MFS
-
What is the purpose of having stored procedures in a database?
nithui
- Mar 11th, 2009
1. It is used to increases the performance of the application. Because when we create Store procedure, they are compiled and stored in database. Later when applications call them, they are general...
sreyas kvm
- Feb 9th, 2008
Stored procedure is a pre-compiled execution block,so they do not want to wait as the time for compilation.It is call from the server.It reduce the execution time
-
How do you join two files with different layouts
sitharaju
- Mar 11th, 2009
I think your question is to join a serial file and a multifile,?if that is the case use broadcast component after the serial file and before join.
Shilpi
- Aug 12th, 2007
If the layout is?totally different ----use Fuse Component
-
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.
-
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 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
-
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 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?
-
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.
Abinitio Interview Questions
Ans