What is Partition swap.
Mainly when we want to load or reload the millions of records in fact tables which in partitioned , either we can truncate the partition and load data or we can delete partition and load data which is rather performance hits .
This kind of scenarios we can use the partition exchange mechanism of oracle to load data faster .
Syntax for partition exchange
Mainly when we want to load or reload the millions of records in fact tables which in partitioned , either we can truncate the partition and load data or we can delete partition and load data which is rather performance hits .
This kind of scenarios we can use the partition exchange mechanism of oracle to load data faster .
Syntax for partition exchange
ALTER TABLE big_table2 EXCHANGE PARTITION big_table_2007 WITH TABLE big_table WITHOUT VALIDATION UPDATE GLOBAL INDEXES;
This is very effective method for faster loads
refere following link for more information
Partition exchange
How to use it with informatica
User StoreProcedure transformation
Load data into tmp target table first and then call store procedure transformation to exchange partition with tmp table