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 ?
1394Whenever 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?
1052What 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.
1423Input 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
1534Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
1808What will be the output of using partition by Round-Robin after the partiton by key in ab initio?
1 2231What will be the skew for, input file->partition by key-> partition by round robin->output file
1015Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
1032How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
1055
List out some of the air commands used in abintio?
What is a data processing cycle and what is its significance?
explain the environment varaibles with example?
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?
Mention what is the syntax for m_dump in abinitio?
Explain what is de-partition in abinitio?
When we should use 'jobid' for commit table (Output table component?? How to use in abinitio graph?
We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?
What do you mean by the term data warehousing? Is it different from data mining?
Describe the grant/revoke ddl facility and how it is implemented?
What is the difference between look-up file and look-up, with a relevant example?
Mention some file extensions which are used in abinitio?
What do you mean by the overflow errors?
How co> operating system natively processes the data?
What is $mpjret?