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?
- 0 Answers
- 772 Views
- I also Faced
- E-Mail Answers
Mention what is the role of co-operating system in abinitio?
What is publickey and private key?what is the use of this two keys?
what is the relation between EME , GDE and Co-operating system ?
Explain PDL with an example?
What are the different types of partition components in abinitio?
) Diff.between Output index and Output indexes?
What is the purpose of having stored procedures in a database?
How transaction file different from that of a sort file?
How to create a repository in abinitio for stand-alone system(local nt)?
Hi friends, what are the new features in abinito3.0?
Can you explain the performance and scalability of co> operating system?
Mention what are the different types of parallelism used in abinitio?
Teradata 
