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 ?

 761

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?

 562

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.

 860

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

 637

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

 815

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

 853

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

 971

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

 1 1234

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

 419

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

 938

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

 610

Code check-in and check-out commands in AbInitio

 3357

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?

 532

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

 470

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

 650

Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

What do you understand by a cartesian join?

659

What are the different types of parallelism in ab initio?

723

Mention some file extensions which are used in abinitio?

614

What are differences between different versions of co-op?

631

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1479




What are the functions of the replicate and dedup component?

622

What do you know about abinitio?

758

How do you improve the performance of a graph?

674

What is de-partition in abinitio?

882

When running a stored procedure definition script how would you guarantee the definition could be rolled back in the event of problems?

651

Can anyone give me an example of realtime start script in the graph?

665

What do you mean by data sorting?

629

How can I run the 2 gui merge files?

690

Difference between informatica vs ab initio?

703

What are the Types of parallelism in detail?

699

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