Showing posts with label Data Warehouse. Show all posts
Showing posts with label Data Warehouse. Show all posts

1/6/13

Data Warehouse Design Approaches

In our previous posts we have got to learn about Data Warehousing Objects, different kinds of Data Warehouse schemas and Data Warehouse Basics. Now it time we learn about how to build or design a Data Warehouse. 

Designing or Building of a Data Warehouse can be done following either one of the approaches. These approaches are notably known as:

* The Top-Down Approach
* The Bottom-Up Approach

These approaches are defined by the two of the bearers of Data Warehousing namely Ralph Kimball and Bill Inmon.


10/27/12

Data Warehousing Object: Dimension Tables Types

We had our last post on Fact Tables in Data Warehousing. This post is on Dimension Table Types. Along with Fact Tables there are many types of Dimension Tables which are used in Data Warehousing.

 Dimension Tables are those tables which contain attributes that helps in describing the facts of the fact table.

 The following are types of Dimension Tables:

 * Slowly Changing Dimensions
* Junk Dimensions
* Confirmed Dimensions
* Degenerated Dimensions


9/26/12

Data Warehousing Object : Fact Tables

In the previous post on DW we saw different types of Data Warehousing Schemas. So the different types of schemas had one thing in common and that was, they had Fact and Dimension Tables. So these are nothing but Data Warehousing Objects. 

Apart from Fact Tables, Dimension Tables there are other things which come under Data Warehousing Objects, they are:

* Fact Tables
* Dimension Tables
* Hierarchies
* Unique Identifiers
* Relationships

In today's post we will be taking a look in Fact tables.

9/15/12

Data Warehousing SCHEMAS

A schema is a collection of database objects, including table, views, indexes and synonyms.

 There are some special architectures which arranges the schema objects in the schemas models. The most common of them are :

 * Star Schema
* Snowflake Schema
* Fact constellation Schema


9/4/12

What is a Data Warehouse?

A very exciting and one of the hottest topic currently in the IT world is DATA WAREHOUSE. The tools which are used for the same are among some of the hot skills example INFORMATICA, TERADATA etc.