![etl processes etl processes](https://www.businessintelligencebase.com/images/etl.png)
The Initial Extract Date defines a cut-off so that not all records are loaded into the data warehouse. Records created after an "Initial Extract Date" from tables that are sources for fact tables.
#Etl processes full#
Oracle BI Applications has two ETL modes for loading data into the Oracle Business Analytics Warehouse: full and incremental.ĭuring a full load, Oracle BI Applications extracts:Īll records from tables that are sources for dimension tables. You then execute the load plan to perform the ETL process.įor more information about working with Oracle BI Applications load plans, see Chapter 2, "Managing Load Plans." For information about the topic of load plans in the context of Oracle Data Integrator, see Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator. A transactional data source is associated with one or more data servers.Īfter you define the load plan, you then generate it to build it in the ODI repository. Each fact group belongs to a specific functional area or areas that are associated with one or more offerings, which, in turn, are related to a data server. This selection determines which steps need to be performed during the ETL process. You define a load plan in Oracle BI Applications Configuration Manager by selecting a data source and one or more fact groups.
![etl processes etl processes](https://miro.medium.com/max/5120/1*9O5Lu20Zd_EFL6MSIdt5eA.jpeg)
Depending on the step type, the steps can be executed conditionally, in parallel or sequentially. Each step can contain several child steps. A load plan is made up of a sequence of several types of steps. If you change the default ODI repository ID, make sure the new value is greater than 500.Ī load plan is an executable object that comprises and organizes the child objects (referred to as steps) that carry out the ETL process. Having a repository ID greater than or equal to 500 is critical to ensure that the objects you create do not overlap with any current or future Oracle BI Applications objects. This ID is part of the internal ID for every object that is created within the ODI repository. Note that the default ODI repository ID is 500. Both the master and work repositories are set up during the Oracle BI Applications installation process. The master and work repositories must reside in the same database schema, and the database type must be Oracle. This is the development and execution repository. A master repository is usually associated with multiple work repositories, but work repositories are always attached to a single Master repository Topology of resources, security, version management. The ODI Repository for Oracle BI Applications comprises two repositories: