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 ?

1301

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?

954

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.

1306

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

1077

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

1584

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

1413

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

1658

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

1 2058

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

903

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

1368

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

1023

Code check-in and check-out commands in AbInitio

4243

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?

933

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

904

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

1023

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

2011

What information is provided by .dbc file extension for connecting to the database?

1115

What are the Types of parallelism in detail?

1085

What is $mpjret?

1077

Explain how you can run a graph infinitely in ab initio?

1047

What is a cursor? Within a cursor, how would you update fields on the row just fetched?

1119

How abinitio eme is segregated?

1229

When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?

1098

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

1046

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

1065

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

1206

Explain the difference between the truncate and delete commands?

1097

What is de-partition in abinitio?

1316

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

1088

What are the different types of parallelism in ab initio?

1148

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