-
-
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.
-
Config Variables in Abinitio
What is the need of config variables in abinitio?(ab_job,ab_max_core) and where to define them?
nagarjuna
- Jul 22nd, 2011
For all ab-initio config variables the command starts with AB_
-
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
-
Data Modelling
What data modelling do you follow while loading of data to tables? Also the DB you are inserting the data has Star schema or Snow flake schema?
kalyanvadlamudi2kn
- Jan 12th, 2014
It depends on schema, since the star/snow flake schema has one fact table attached to multiple dimensions
so, I would go with 3rd normalized form. -
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.
-
How does component folding works in Ab Initio?
sham2sushil
- Apr 27th, 2010
It reduces the number of processes created by the graph and can enhance performance of the graphs. It is combined saveral graph componants at a time in a group during run. groups runs as a single process and use the less memory during runtime.--Shambhu
-
Range Lookup
What is Range Lookup?
sham2sushil
- May 2nd, 2010
Its returns the first data record When you defined the range indicated by the lower and upper bound arguments. --Shambhu
-
Package editor
What is "Package" and "Package Editor" and how and why it is used.
hari.pardha
- Dec 18th, 2011
Once you log in to transform editor click on view and go to package editor. It is used to have extra tranform abilities like intialise, finalise etc
-
Force_Error with Condition
How to pass force_error with condition?
DilipPanda
- Apr 4th, 2010
You can write force_error function in following fashionout:reformat(in)beginif (in.cust_name=="XYZ") force_error("Invalid Customer");out.*::in.*endHope this helps...
-
Convert 4 way mfs to 8 way mfs
How to convert 4 way to 8 way mfs files without throw down of data in the file?
sham2sushil
- Apr 27th, 2010
1. To convert 4 way to 8 way partition we need to change the layout in the partioning component.2. Departition the data then repartition.--Shambhu
-
Wrapper and .ksh in Ab Initio
Why wrapper scripts are used in job scheduler to run graphs in Ab Initio? Why cannot we use .ksh script in Job scheduler to schedule job?
Abinitio Interview Questions
Ans