Loading data using partition exchange
Table partitioning is a commonly used strategy in data warehouse systems, and although the many reasons for partitioning a table are beyond the scope of this book, suffice it to say that performance and high availability are among the primary reasons for doing so. From a data loading perspective, the gold standard ELT strategy for targeting a partitioned table is universally considered to be the partition exchange loading (PEL) method. This advanced technique involves five basic steps:
- Create a standalone database table that is structurally identical to the partitioned table.
- Load all source records into the standalone table that comply with the boundary definition of a specific partition within the partitioned ...