A key component to any Business Intelligence (BI) Architecture is the Extract, Translate and Load (ETL) process. The ETL process is typically scheduled on a daily basis and is capable of data movement from legacy systems into a data warehouse. It is also used to facilitate the work of the database administrators who connect different branches of databases as well as integrate or change the existing databases.
Tags: Data Warehousing, Oracle, Informatica, Business Intelligence, Sridhar Kasthuri, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
This blog introduces and explains the detailed step by step process for executing the Domain Load to Business Analytics Warehouse. Here, we are illustrating for the Student information Analytics data using the new OBIA 11g which is supported only for PeopleSoft 9.0 Campus Solutions. This blog can be used similarly for any other Analytics using OBIA 11g.
Tags: Student Information Analytics, Data Warehousing, OBIEE, Veera Reddy Ramidi, Oracle, Business Intelligence, Tutorial, Oracle BI, Oracle BI Applications, Examining OBIA 11g, Blog
The most common question faced by any ETL developer or a Data Warehouse project implementer is always related to performance. Whatever the tool may be, and however fast the job may be running, the end user will always desire something which is a little faster and quicker.
Tags: Data Warehousing, Training, Sharath Venkataranga, Business Intelligence, Tutorial, Oracle BI Applications, Examining OBIA 11g, Oracle Data Integrator (ODI), Blog
