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

Answer Posted / mallika

Data Mart is subject oriented likes sales finance,etc..It
gets data from few no.of sources.It is maintained
departmental wise.

data warehouse consists of all subjects.Its an integrated
structure.it gets data from more number of sources.It is
maintained Centrally.Group of datamarts make a datawarehouse

Is This Answer Correct ?    39 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain grouped cross tab?

2193


How do you define data block size?

589


Can we start and stop single session in concurent bstch?

530


What is the goal of optimizer?

589


Is there any rownum object from which we can do this?

522






How to add a number to a macro variable?

553


How can we run the graph?

583


Explain what are fact, dimension, and measure?

556


What is cubes?

621


What is called dimensional modelling?

580


What is batch processing?

587


Could any one explain me how to create cascading prompts?

509


Explain can report net connect multiple datasource at a time in report creation time?

495


Explain what are components of reportnet?

557


After the generation of a report to whom we have to deploy or what we do after the completion of a report?

506