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

Answer Posted / harshad

More Spcific

DW Will be your target for historical data and will be use
for Analysis.

Data Mart would be your Source for DW and will be subject
oriented.

Is This Answer Correct ?    22 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what is the difference between power center & power mart?

529


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

517


what are the others of "bad files" and "discard files" when using sql*loader?

1632


What are the data marts?

529


For faster process, what we will do with the universe?

574






What is drill-through?

580


What are the different types of segments?

552


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?

571


What is the difference between star and snowflake schemas?

604


Explain is fact table?

518


What are steps we have to follow in designing the userfriendly universe?

558


Explain what is the metadata extension?

588


How much data hold in one universe.

560


What is data analytics in simple terms?

557


What is the limit to the number of sources and targets you can have in a mapping?

565