Difference between informatica vs ab initio?
How transaction file different from that of a sort file?
Mention what is abinitio?
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 ?
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?
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.
How can we increase the loading performance of oracle table in AbInitio?
What happens when we provide null key to sort, merge and pbks in Abinitio ?
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
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
What will be the skew for, input file->partition by key-> partition by round robin->output file
what is the output when -1 is put in select_expr of FBE?
How to replace last 4 digits of an input column with XXXX given input column has 12 digits?
Code check-in and check-out commands in AbInitio
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?