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
- 555 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How scientific data processing is different from commercial data processing?
What are the different types of partition components in abinitio?
What is the difference between a utility and api in a RUN SQL component
How you can delete an object from a tag ? How to use in abinitio graph?
what is different daily and monthly develop the abinitio graphs?
. What is adhoc multifiles? How to use in abinitio graph?
How to create a repository in abinitio for stand-alone system(local nt)?
how will i can implemate Insert,Update,delete in abinitio? how will u view MFS in unix?what is diff/btween conditional dml& conditional component?
What is the max core of a component?
Mention what is the syntax for m_dump in abinitio?
Describe the process steps you would perform when defragmenting a data table. Does this table contain mission-critical data?
How can you SORT an already partitioned (round-robin) data ? How to use in abinitio graph? 3. How internally partition by key decides which key to send in which partition ? How to use in abinitio graph? 4. What is PDL ? Give him a shell type parameter and ask him to convert it to PDL. How to use in abinitio graph? 5. As shell type parameters are not supported by EME, then how you can use shell type parameter (If you don't want to use PDL) without hampering lineage diagram ? How to use in abinitio graph? 6.How you can generate dml from a COBOL copy book ? How to use in abinitio graph? 7. How you can convert from ebcdic to packed decimal ? How to use in abinitio graph?
Teradata 
