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 ?
1346Whenever 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?
1008What 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.
1373Input 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
1472Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
1754What will be the output of using partition by Round-Robin after the partiton by key in ab initio?
1 2166Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?
990How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on
986
What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?
What are the different types of parallelism used in abinitio?
How can we increase the loading performance of oracle table in AbInitio?
What is the difference between a scan component and a rollup component?
What is the function that transfers a string into a decimal?
Do you know what a local lookup is?
What do you mean by a transaction file?
What are the primary keys and foreign keys?
What kind of layouts does abinitio support?
what is the output when -1 is put in select_expr of FBE?
What are the six data process products of ab initio (architecture of ab initio)?
What are the components new in 2.14 compared to 1.8 and State the usage of the components?
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.
To which project that prefix will set is to private project or public project or both?how and where to set?
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