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

Answer Posted / jaya

datamart is something which consists of only one type of
data whereas datwarehouse consists of data of different
type.For example all the organisation data say data related
to finance department,HR,Banking dept are stored in
datawarehouse whereas in datamart say only finance data
will stored.So datawarehouse is a collection of different
datamarts.

Is This Answer Correct ?    19 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between cold fusion 5 and cold fusion mx 6?

590


What a static and local variable?

597


List any five applications of data warehouse.

557


Explain what is a three tier data warehouse?

549


What are the steps of implementing data warehousing?

541






Difference between cold fusion mx 6 and cold fusion mx 7?

472


Suppose we want to display zero when null values coming to report how can we do that?

537


I know of using applysimple, but there are other ways too?

564


What are data modeling and data mining? Where it will be used?

551


What is fact less fact table? Where you have used it in your project?

511


Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?

528


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

535


Explain have you ever been in a real dilemma at work? What did you do to get out of it?

537


Explain what is batch and describe about types of batches?

615


What is called data cleaning?

622