What is the difference between a data warehouse and a data mart?
Answer Posted / thakkalpelly anil
a data warehouse is a relational database which is
specially designed for analysis purpose rather then for
transactional purpose.
a datmart is subject oriented database which gives the data
about each and every individual department in an
organisation.
Is This Answer Correct ? | 47 Yes | 9 No |
Post New Answer View All Answers
Explain difference between snow flake and star schema.
What needs to be done while starting the database?
How can we schedule the graph in unix?
Ist the schema that a data warehouse system can implements.
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How did you plan your Data ware house project?
What are cluster analysis in data warehousing?
Explain what are the different types of join operations?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
Where the data cube technology is used?
What are the reasons to use a chameleon method in data warehousing?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain what are the various transformation available?
What is a linked cube?