Data warehouse is a collection of multiple subjects and many data sources.

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

Question Posted / geeta yadav

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

Please Help Members By Posting Answers For Below Questions

What are universe requirements?

963

How to create diff. Types of templates?

980

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

956

Define Data Warehousing?

1098

What are the steps of implementing data warehousing?

971

How can we determine what records to extract?

1023

What is aggregate fact table?

933

Explain difference between snow flake and star schema.

958

Is there any difference in testing database and data ware housing?

2692

How to reduce warnings?

897

Compare aggregates and data marts

2690

What is vdl (view definition language) explain?

984

What is the difference between er modeling and dimensional modeling?

1073

What is difference macros and prompts?

2218

Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?

895