Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone explain difference between Database, Data warehouse
and Data mart with some example?````
- 4 Answers
- 6659 Views
- I also Faced
- E-Mail Answers
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
What are the advantages of partitioning?
Write a SQL queries on Self Join and Inner Join.
What kind of problems occurs if we do not implement proper locking strategy?
What is postgresql server?
How except clause is differs from not in clause?
What is truncate table?
What do you mean by data manipulation language?
Why transaction is important?
Does partitioning improve performance?
What is a non-clustered index?
Define synonym?
Can you please explain the difference between function and stored procedure?
What is difference between clustered index and non clustered index?
Mention what are the different types of ssrs reports?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
