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 ?

 753

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?

 554

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.

 848

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

 620

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

 805

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

 845

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

 961

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

 1 1227

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

 405

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

 923

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

 602

Code check-in and check-out commands in AbInitio

 3333

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?

 522

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

 459

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

 637

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

What do you understand by a cartesian join?

648

What is the difference between look-up file and look-up, with a relevant example?

688

Describe the evaluation of parameters order in ab initio?

952

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

591

How co> operating system natively processes the data?

604




What is common among data validity and data integrity?

587

Why might you create a stored procedure with the with recompile option?

635

What are the benefits of data processing according to you?

693

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

1274

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

610

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2133

You can ask about different vector functions. How to use in abinitio graph?

5017

What are the operations that support avoiding duplicate record?

913

What are the differences between informatica and abinitio?

709

How you can run a graph infinitely in ab initio?

768

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