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

  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 ?

 296

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?

 228

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.

 372

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

 216

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

 304

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

 224

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

 249

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

 1 281

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

 119

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

 35

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

 21

Code check-in and check-out commands in AbInitio

 22

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?

 23

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

 28

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

 19

Post New Ab Initio Questions






Un-Answered Questions { Ab Initio }

We know rollup component in abinitio is used to summarize group of data record then why do we use aggregation?

340

What do you know about abinitio?

310

When we should use 'jobid' for commit table (Output table component??

6474

How co> operating system natively processes the data?

276

How many components in your most complicated graph?

374




Have you worked with packages?

296

Mention what is the syntax for m_dump in abinitio?

389

Explain the methods to improve performance of a graph?

327

What are the primary keys and foreign keys?

286

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?what are differences between different versions of co-op?

266

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

284

What are the Graph parameter?

318

Explain data flow graph with an example?

299

What are the reasons for which business can trust the approach of data processing?

275

What is the use of the co> operating system in ab initio?

281

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