ODI Load Plan Types in BIACM

Load Plan Types:

There are 3 main phases: 

1. Source Data Extract (SDE)
   The SDE phase consists of tasks extracting data from your different source systems. This phase loads all your staging tables and requires source system downtime
2. Source Independent Load (SIL)
   The SIL phase loads data from your staging tables into their respective dimension or fact tables.
3. Post Load Process (PLP)
   The PLP phase loads data into aggregate tables or some other facts requiring additional data processing. The SIL and PLP phase requires data warehouse downtime to complete the load process.

Regards,

Zafar Habib