Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 ?

559

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?

445

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.

677

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

440

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

526

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

602

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

745

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

1 814

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

296

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

477

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

309

Code check-in and check-out commands in AbInitio

2002

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?

316

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

298

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

310


Post New Ab Initio Questions

Un-Answered Questions { Ab Initio }

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

503


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

539


List out some of the air commands used in abintio?

490


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

531


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

296






What do you understand by overflow errors?

507


Can you explain data flow graph with an example?

515


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

1677


What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

300


Mention what dedup-component and replicate component does?

494


Have you used the rollup component? Describe how?

509


The methods to improve performance of a graph?

500


Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump

1450


Mention what the difference between “look-up” file and “look is up” in abinitio?

639


What is data encoding?

601