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

Ab Initio Interview Questions

Questions Answers Views Company eMail

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1344

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

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

1373

How can we increase the loading performance of oracle table in AbInitio?

1149

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

1675

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1471

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1748

What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

1 2160

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

969

what is the output when -1 is put in select_expr of FBE?

1406

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

1085

Code check-in and check-out commands in AbInitio

4315

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

987

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

979

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

1080

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

Explain the ab initio etl tool in high level?

1133

Name any two stages of the data processing cycle and provide your answer in terms of a comparative study of them?

1121

The methods to improve performance of a graph?

1075

In abinitio, what types of parallelism are used?

1091

What are the differences between different versions of co-op?

1004

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

1273

What are the Types of parallelism in detail?

1142

What is broadcasting and replicate?

1171

How can you export a component’s internal parameters ?

2394

What is local and formal parameter?

1402

Suppose you find the term validation mentioned with a set of data, what does that simply represent?

1036

What are the facts that can compromise data integrity?

1147

Do you think effective communication is necessary for data processing? What is your strength in terms of same?

1144

Where $mpjret is used in ab-initio?

1146

How to move or copy the project parameter or project object to my sandbox?

2308

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