Can anyone explain difference between Database, Data warehouse
and Data mart with some example?````
Answer Posted / sarva
database:collection of related records in 2D store media
eg:attendance register,empoly table;
whereas in DWH its capacity is enterprise wise and
multidimensional way eg:banking or any company websites;
whereas in datamart its capacity is department wise data
storage media eg:official logins.
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Write a sql query to display the current date?
What is NOT NULL Constraint in sql server 2012?
Explain boyce and codd normal form(bcnf)?
Does group by sort data?
Define model database?
How can we solve concurrency problems?
What is data set in report?
What is the purpose of floor function?
What is SQL Azure Firewall?
What is clustered index
What is the default fill factor value?
Do you know what is normalization of database? What are its benefits?
Explain different types of self contained sub query?
What is sql server replication? : sql server replication
Explain some stored procedure creating best practices or guidelines?