Ab Initio Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Ab Initio Interview Questions

Questions Answers Views Company eMail

What is the difference between reformat and redefine format?

IBM, TCS,

4 32593

what is difference between chk point n phase.Say im loading a file (containig 1 lakh records) and my graph fails after loading 50,000th record.What is the advantage of using check point in this case. Will i be able to start from 51000th record.

IBM,

1 10740

IBM,

1 8396

How can you increase the number of ports of your output flow? What is the limit? Can i have 20 out ports?

IBM,

2 12628

If m loading a file of 1 million records.and the graph fails after loading 10,000 records. In this case if we use rollback command then what will happen?

IBM,

4 16199

how to create a new mfs file? where will we specify the number of partition eg 4 way ,8 way?

IBM,

4 32554

difference betwween check point and phase?

IBM,

2 14425

how does deadlock occur?

IBM,

6 19058

how to prepare scd2 in abinitio

CTS,

1 21564

hi, am put into Ab initio now. I need some material for to learn it!! i have to give a test also.. can anyone help me provide material please....

1 4919

What is the default layout of a component ? Is it mandatory to set the layout of a component ?

IBM,

3 12706

How does PBK and Sort component and Join(in memory sort) work?I mean in the join component i have used In Memory Sort,so how will it work in terms of performence as compared with PBKand Sort Component?

1 5127

What is the difference between Generate Records Component and Create Data Component?

Steria,

6 27351

Can we specify checkpoints without Phases?

IBM, Tech Mahindra,

3 16185

Can you read multiple input files using one input file component ?(same DML)

IBM,

4 19491

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

1004

Describe the evaluation of parameters order in ab initio?

1528

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

1036

difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?

2835

What are the steps to create a repository in ab initio?

1258

What do you mean by the overflow errors?

1369

What are the Types of parallelism in detail?

1142

How to run a graph infinitely?

1121

What is the difference between check point and phase?

1309

What is data mapping and data modelling?

1554

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

2020

What are the Graph parameter?

1156

What is MAX CORE of a component?

1320

Mention what information does a .dbc file extension provides to connect to the database?

1335

What is flow buffering ? How it reduces the chances of having deadlock ? How to use in abinitio graph?

3457

For More Un-Answered { Ab Initio } Questions Click Here