| Features of Dimension Table & Fact Table |
This article explains the features of Dimension and Fact Table . Dimension Table features
1. It provides the context /descriptive information for a fact table measurements.
2. Provides entry points to data. |
| Author :Mr.Aditya, INDIA |
|
| How a Data Warehouse is different from Database |
Database is used to store the transaction data in the form of normalized tables. In Data Warehouse also we preserve the data but the data is in a summarized form, historical data is preserved and Non Volatile.This features makes the Data Warehouse is fit for preparing Decision making system /Business Intelligence System.
|
| Author :Mr.Lakshman, INDIA |
|
|
