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
- 6707 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 is a trigger? Why we need it?
What is snapshot parameter in ssrs?
What is an indice?
Explain the difference between clustered and non-clustered index?
What is difference between temp table and cte?
Explain ms sql server reporting services vs crystal reports?
Is BCNF better than 2NF & 3NF? Why?
Is there any difference between primary key and unique with the not null condition?
Do you know what is sql injection?
What is the purpose of floor function?
How to create an multi-statement table-valued function?
How to insert multiple rows with one insert statement in ms sql server?
What is statement level trigger?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the difference between having clause and where clause in sql server?
