Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Ab Initio
  2. Suggest New Category
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 ?

 1070

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?

 764

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.

 1096

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

 866

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

 1286

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

 1189

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

 1306

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

 1 1670

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

 644

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

 1158

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

 844

Code check-in and check-out commands in AbInitio

 3898

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?

 748

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

 697

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

 852

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

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

822

Mention some file extensions which are used in abinitio?

827

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

845

What are the various types of layout supported by abinitio?

768

What is data encoding?

962

explain the environment varaibles with example?

822

explain checkin and checkout?

861

What is the purpose of having stored procedures in a data-based?

766

Have you used rollup component? Describe how.

840

List out the file extensions used in abinitio?

833

How to compare two dmls in abinitio

1536

Tell us about the architecture of abinitio.

865

How co> operating system natively processes the data?

840

How can you export a component’s internal parameters ?

2131

How abinitio eme is segregated?

1042

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