Translate

Data warehousing Architecture

Wednesday, April 23, 2008

Difference between Data Warehouse & Data Mart

DATA WAREHOUSING Focuses enterprise level, With different Subject.
Example : IN LIC
we have loan & Insurance, for both of these if we create Data Warehouse then it is said to be Data Warehousing

DATA MART Focuses singal line of business.

Example : IN LIC
if we create separate Data Warehousing for both these, then it is said to be Data Mart.
Data Mart is sub set of DataWarehosuing

Sunday, March 30, 2008

Data Warehousing Architecture

Difference between Transactional and Warehoused Data

TRANSACTION PROCESS Vs DECISION SUPPORT

1) Operational & Analytical

2) Simple Queries & Complex Queries

3) Results of 1-30 rows & Results of 1-30 million rows

4) Data manipulation & Data retrieval

5) Dynamic Data & Static Data.

Sign up for PayPal and start accepting credit card payments instantly.