What is the difference between a data warehouse and a data mart?

Answer Posted / geeta yadav

Data warehouse is a collection of multiple subjects and many
data sources.
Data Mart is a single object and few data sources.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the extension of file to save template?

521


How can you communicate with web server (apache or iis) from coldfusion?

554


Explain what does level of granularity of a fact table signify?

538


What is the purpose of Dataware Control?

608


How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

569






What are session timeout and application timeout?

539


In document how to create metrics?

563


What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

542


Explain why dimenstion tables are denormalized in nature?

520


How to create different types of templates?

524


Explain what is batch and describe about types of batches?

616


What is difference between model & package?

579


What is dimension modeling?

540


Explain the structure of cold fusion?

601


Explain when do we analyze the tables? How do we do it?

624