Can anyone explain difference between Database, Data warehouse
and Data mart with some example?````
Answer Posted / manoj pandey
1. Database: primarily is a collection of Tables that are normalized upto 3-NF and can be interrelated by FKs. It is an OLTP system which is meant for storing data of Information systems, like a CRM, ERP, Company/College/School record management system, and similar Data Entry other tools.
2. Data Warehouse: DW or EDW (Enterprise DW) is a system created by combining more than one Database systems, and/or by getting data from different Sources like heterogeneous Databases, flat-files, data feeds, etc. The tables in this system are de-normalized like in 1-NF, so that all related information is in a single table. Is is an OLAP system which is meant mainly for Reporting.
3. Data Mart: are built on top of a Data Warehouse, either by creating Views from underlying tables or a CUBE from fact & dimension tables.
~Manoj (http://sqlwithmanoj.wordpress.com)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to integrate the ssrs reports in application?
please differentiate between delete and truncate?
What are the different normalization forms?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Name three of the features managed by the surface area configuration tool? : sql server security
List some of the rules that apply to creating and using a ‘view’
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What are character string data types in ms sql server?
Give me any three differences between Truncate and Delete.
What is query cost in sql server?
What are the advantages of using stored procedures?
What is service broker? : sql server database administration
ow to bring suspect mode datbase online from scratch
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Differentiate sql server reporting services vs. Crystal reports?