Posted by Dylan Wan on May 14, 2013
One of the major change introduced in BI Apps 220.127.116.11.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 of tasks exactly in order to use DAC to manage the task execution of the Informatica workflow tasks.
Load Plan and Load Plan Generator was designed for addressing this requirement.
Here is a good article that describes the story.
Posted in BI Application, Business Intelligence, DAC, Data Warehouse, ETL, Infomatica, OBIA, ODI, Oracle, Oracle Data Integrator | Tagged: DAC, Load Plan, LPG, Oracle Load Plan | Leave a Comment »
Posted by Dylan Wan on January 28, 2008
I would like to go over some of the embedded BI related technologies you can use to make the data from BI Apps embedded in the OLTP systems.
In this post I will describe the Micro ETL feature from DAC.
Read the rest of this entry »
Posted in BI, BI Application, BI Work, DAC, Data Warehouse, OBIA, OBIEE, Oracle, Oracle BI Suite EE | 1 Comment »
Posted by Dylan Wan on January 27, 2007
“Sunopsis’ ability to connect a wide variety of data sources and targets will allow Oracle to address the heterogeneous data management environments its enterprise architect customers must contend with.
This acquisition could be a big win for the Siebel, PeopleSoft, and JD Edwards customers who, following the acquisitions by Oracle, find themselves smack in the middle of a perhaps unwanted Oracle-dominated ecosystem.”
Please read the entire paper here: Read the rest of this entry »
Posted in BI, DAC, ETL, OBIEE, Oracle, Oracle BI Suite EE, Oracle Data Integrator, OWB, Siebel Analytics, Sunopsis | Leave a Comment »