BusinessObjects Topics

Search This Blog

BusinessObjects Topics

Sunday, July 20, 2008

Data warehouse Concepts - Day 2 i




What is datawarehouse?

A data warehouse is built on relational database that is designed for query and analysis rather than for transaction processing. It usually contains historical data derived from transaction data, but it can include data from other sources. It separates analysis workload from transaction workload and enables an organization to consolidate data from several sources.
In addition to a relational database, a data warehouse environment includes an extraction, transportation, transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine

Characteristics of a data warehouse

Subject Oriented
Integrated
Nonvolatile
Time Variant

Different Types of Data

Metadata
Dimension data
Fact Data
Aggregated Data

Data warehouse Architectures



Dimension Modeling


Identify a Business Process
Identify Grain
Identify elements which describe the process (Dimensions)
Identify elements which measure process(facts)10


0 comments:

Tags

Oracle Data warehouse Business Objects Business Objects XI R2 Business Objects XI 3 PLSQL BOBJ BI News Business Objects FAQs bo DataModeling Concepts Databases Server Administration BOCP-BOE Business Intelligence (BI) MS SQL Sever Database Universe Designer Certification Designer REPOSITORY SAP BI SAP Education Supervisor BO Reporter/ functions BO XI 4.0 BOXI 3.1 Business Objects Designer Downloads Fan / Chasm Trap Functions Integration and Certification Loops MS SQL Sever Administration OLAP QaaWS SAP Business Objects SAP BusinessObjects Business Intelligence 4.0 Star Schema Universe Design Web Intelligence WebIntelligence