Articles on Emerging Technologies, Cloud Computing and Cyber Security

Tuesday, November 7, 2017

ETL Phases


Oracle BI Applications ETL processes includes three main phases: SDE, SIL, and PLP.
  • SDE stands for Source Dependent Extract. In this phase, SDE tasks extract data from the source system and SDS and stage it in staging tables. SDE tasks are source specific.
  • SIL stands for Source Independent Load. Load tasks transform and port the data from staging tables to base fact or dimension tables. SIL tasks are source independent.
  • PLP stands Post Load Process. PLP tasks are only executed after the dimension and fact tables are populated. A typical usage of a PLP task is to transform data from a base fact table and load it into an aggregate table. PLP tasks are source independent.

0 Comments: