How you can generate surrogate key? How to use in abinitio graph?
Answer Posted / archana reddy
next_in_sequence() -serial files (next_in_sequence()*number of partitions)+this partition() -multi files
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What are the differences between informatica and abinitio?
Explain PDL with an example?
List out some of the air commands used in abintio?
What are the operations that support avoiding duplicate record?
Give one reason when you need to consider multiple data processing?
How to add default rules in the transformer?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
When using multiple dml statements to perform a single unit of work, is it preferable to use implicit or explicit transactions, and why?
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 ?
What do you understand by a cartesian join?
Mention what is abinitio?
difference between paramaters inputparameters,Local parameters, Formal parameters, Sand box parameters,Project parameters and export parameter?
What is sandbox?
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 a local lookup?