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
Translate
Wednesday, April 23, 2008
Sunday, March 30, 2008
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.
Subscribe to:
Posts (Atom)
