PARTITION EXCHANGE LOAD Method
I need some assistance in understanding how to implement Partition Exchange Load (PEL) command. I have a requirement of having about 100 odd fact tables that will be loaded by our ETL many times a day. These tables are being constantly read by our COGNOS reports and we want to have minimal disruptions caused by ETL write processes.
So naturally, I thought that Partition Exchange Load can give us exactly that.
After doing lots of reading we realized that the best way of doing this is:
1. range partitions (month based) on our target tables
2. indexes on our target tables. These are both global and partitioned.