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 32590

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 32553

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 4918

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 27350

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 }

Mention what is the syntax for m_dump in abinitio?

1471

Mention what is a partition and what are the different types of partition components in abinitio?

1180

What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

1235

What will be the skew for, input file->partition by key-> partition by round robin->output file

969

Difference between output_index and output_indexes in reformat

1296

How do you truncate a table?

1173

How transaction file different from that of a sort file?

1416

What is data mapping and data modelling?

1554

How to execute the graph from start to end stages? Tell me and how to run graph in non-Abinitio system?

1253

What is rollup component?

1243

What is the function that transfers a string into a decimal?

1156

What do you mean by the term data warehousing? Is it different from data mining?

1219

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1131

What are the different types of parallelism in ab initio?

1221

What are “business rules” in ab initio business rules environment (bre)?

2023

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