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 ?

1314

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?

963

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.

1341

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

1098

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

1615

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

1423

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

1670

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

1 2085

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

920

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

1382

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

1036

Code check-in and check-out commands in AbInitio

4258

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?

942

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

916

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

1032

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

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

1196

Hi friends, what are the new features in abinito3.0?

2772

What do you understand by overflow errors?

1173

What is broadcasting and replicate?

1110

When we should use 'jobid' for commit table (Output table component??

8987

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

2782

What is the purpose of having stored procedures in a database?

1104

How to create repository in abinitio for stand alone system(local nt)?

1185

What is a rollup component? Explain about it.

1131

What is a partition?

1120

Can you explain the co>operating system’s processing model?

1055

What is data encoding?

1199

In abinitio, what types of parallelism are used?

1039

Mention some ways for improving performance of a graph?

1052

What is the core of co> operating system?

1110

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