Can anyone explain difference between Database, Data warehouse
and Data mart with some example?````
- 4 Answers
- 6046 Views
- I also Faced
- E-Mail Answers
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
Is there any difference between the primary key and unique key?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
How to resolve the orphan use problem? : sql server security
List some of the rules that apply to creating and using a ‘view’
Define Wed Edition in SQL Azure?
What is an entity-relationship diagram (erd)?
What is the difference between a check constraint and a rule?
How do you Implement SSIS Packages in your Project?
When multiple after triggers are attached to sql table, how to control the order of execution?
What command must you use to include the not null constraint after a table has already been created?
What is user-defined scalar function?
How can you start sql server in different modes?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is the difference between upgrade and migration in sql server?
