Dylan's BI Notes

One of the major change introduced in BI Apps 11.1.1.7.1 is the way how we manage the ETL task sequence and trim the unnecessary tasks. This functionality was accomplished earlier using DAC.  The problem we frequently faced was that the DAC repository and the INFA repository are maintained as two separate repositories.  We have to sync up the name […]

The data warehouse needs to be refreshed periodically to make sure that the data warehouse have the up to date information.  The Incremental Load is the regular ETL process running everyday.  The frequency can vary, but it is commonly seen as nightly job.  To ensure that the incremental ETL job can be finished within a […]

First Go to OTN www.oracle.com/technetwork Go to DOWNLOADS -> Middleware You will see Business Intelligence Applications under Middleware You see both 10g and 11g.  Click on Oracle Business Intelligence 11g downloads You will see BI Apps 11.1.1.7.1 here: Oracle Business Intelligence Applications (11.1.1.7.1)  

Oracle Data Integrator is being used as the ETL tool for BI Apps.  Here are some benefits: 1. Productivity It tasks less efforts for developers to write a ETL map comparing  to other ETL tool. 2. Define ETL flow patterns in KM The reason why now we can take less effort is that the flow […]

BI Application development team is hiring They are hiring a senior application engineer.  The job requires experienced ETL and BI developers with 3- 7 year experience.  

The traditional way of doing ETL nightly is no longer satisfying the requirements.  In the past, we have the ETL “window”  to perform ETL.  The ETL processes typically run as daily or nightly ETL.  We can use the downtime to execute some processes in the OLTP systems to extract their data while we can still […]