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 32533

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 10722

IBM,

1 8383

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

IBM,

2 12613

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 16188

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

IBM,

4 32512

difference betwween check point and phase?

IBM,

2 14411

how does deadlock occur?

IBM,

6 19043

how to prepare scd2 in abinitio

CTS,

1 21545

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 4911

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

IBM,

3 12679

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 5118

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

Steria,

6 27317

Can we specify checkpoints without Phases?

IBM, Tech Mahindra,

3 16175

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

IBM,

4 19471

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

What are the kinds of layouts does ab initio supports?

995

Runtime behavior of Normalize and Reformat

2705

How does the bre work with the co>operating system?

1086

Mention what is rollup component?

1129

What are the different forms of output that can be obtained after processing of data?

1252

How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?

4387

What do you know about abinitio?

1250

Can you explain data flow graph with an example?

1217

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1670

What is local and formal parameter?

1396

What are the features of ab initio?

1105

What does de-partition mean in abinitio?

1271

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?

1000

Can sorting and storing be done through single software or you need different for these approaches?

1114

How to add default rules in the transformer?

1219

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