OBIA - Architecture with Informatica Powercenter and DAC

Oracle Business Intelligence Application (OBIA) use (in some version) :

• Informatica - Powercenter as Data Integration Tool (ETL/ELT)
• and Data Warehouse Application Console as monitoring tool

DAC is a command and control interface for the data warehouse to allow for set up, configuration, administration, and monitoring of data warehouse processes.

• The Oracle Business Analytics Warehouse is a database that contains dimensional schemas.
• The Informatica Repository stores all of the Informatica object definitions for the ETL mappings that populate the Oracle Business Analytics Warehouse. It is a series of repository tables that are stored in a database, which can be a transactional, analytical, or separate database.

• Oracle Business Analytics Warehouse Architecture Components