ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 354,021 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘DW Architecture’ Category

Data Warehousing – Architecture

Posted by Santosh Kumar Gidadmani on January 2, 2011

Data Warehousing Architectures

There are different data warehousing architectures provided by different data warehouse architects. Let us see some of the important data warehousing architectures.

1.

Source: http://www.databaseanswers.org

2.

Source: http://www.gdwsolutions.com

3.

Source: http://www.executionmih.com

4.

Data warehousing architecture with OBIEE tool.

5.

Source: http://www.dwmantra.com

The primary objective of Data Warehouse is to bring together information from disparate sources and put the information into a format that is conducive to making business decisions.
The whole process is to bring the data from heterogeneous data sources to staging area for data quality and based on the business requirements, extract, transfer and load the data into data warehouse. The data warehouse data is designed using data modeling tools like Erwin. The data from the data warehouse is processed and used for different decision support in management using reporting tools like OBIEE, BO, Cognos etc.

– Santosh

Advertisements

Posted in Data Warehousing, DW Architecture | Leave a Comment »

 
%d bloggers like this: