-
What are the different versions and releases of ABinitio (GDE and Co-op version)
Rupal
- Mar 24th, 2006
For GDE 1.10, 1.11, 1.12, 1.13, and 1.15 is latest one. For Co-Op latest one is 2.14.
-
Can anyone give me an exaple of realtime start script in the graph?
prabhupurna
- Jul 7th, 2006
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 t...
K Nagi Reddy
- May 4th, 2006
If you want to run the graph iff the output file exists then you canwrite a script in start script to do the same.psuedo script:if out.dat not existsexitendif
-
-
-
Sift links to MFS files on Unix for Ab Initio ? what is this ....2) $pound what is this 3) $? what for it is used 4) types of loading 5 overwrite when it used ?
cndraa
- May 2nd, 2006
thanks for ur answers ! still im not getting clarity on Sift links to MFS files on Unix for Ab Initio ? what is this.. can u explain with real example
akanksha
- May 2nd, 2006
Link is a command where in unix we use for when the original file is deleted when we create a link the other replaces file exists.Example: ln file 1 file2$# Total number of positional parameters.$? ex...
-
Difference between conventional loading and direct loading ? when it is used in real time .
dontbuckme
- Sep 22nd, 2006
Mis-conception!Utility Mode can be either Direct or Conventional.This question is basically an Oracle question, details please refer to the Oracle sqlldr references.Conventional Load: same ...
Sunitha
- May 12th, 2006
Conventional Load: Before loading the data, all the Table constraints will be checked against the data. Direct load:(Faster Loading) All the Constraints will be disabled. Data wil...
-
-
How to Create Surrogate Key using Ab Initio?
dontbuckme
- Sep 22nd, 2006
For #1, if the layout is not serial, you might need to do something like:(next_in_sequence()-1)*no_of_partition()+this_partition()
Sri
- Jul 28th, 2006
Hi Bava,There r many ways to create Surrogatekey but it depends on your business logic. here u can try these ways...1. use next_in_sequence() function in your transform.2.use Assign key values compone...
-
-
-
-
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 ...
-
-
I am going to get inhouse training on ab initio can anyone state the responsibilities of ETLdeveloper
-
Hello all Ab Initio developers,I have recently graduated and I have just joined the Data Warehousing profession, I got some basic training in Ab Intio for few months now and have a few questions, can someone please help me. 1) How does parallelism work in Ab Initio? When and how do you decided when to use the different types of parallelism?1. Component -- multiple components running on SEPRATE data at the SAME time.2. Pipe-line -- Multiple components running simultaneously on SAME data at the SAME time.3. Data -- data divided into sections and operates on all sections simultaneously.2) How do you select the number of parallelism for Data parallelism? Example: 2-way, 3-way 8-way? 3) What is the number of parallelism Ab Intio can support?4) When and what is the method used to design Ab Initio graphs?5) What is a staging area? Is a staging area required in ETL all the time?6) How does OLAP and ETL work together?Thanks you all, April (Anmol)
ankithak
- Oct 13th, 2007
1) In abinitio component,pipeline parallesim supports default.so the user cant change it. so for data parallesim supports only when ur graph has muitifiles wit...
-
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...
-
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...
-
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
-
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...
-
Open Abinitio in UNIX
How to open Abinitio in UNIX?
cutesree
- Dec 30th, 2009
We cannot open AB Initio in UNIX. We can only run graphs in UNIX using the ksh.
Abinitio Interview Questions
Ans