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
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is called data cleaning?
What is load manager?
What is the extension of file to save template?
Explain about core dimension,
Explain what are the mapping paramaters and maping variables?
Explain what are slowly changing dimensions?
Explain what is a cube in data warehousing concept?
How can we run the graph? What is the procedure for that?
What are the different types of data warehousing?
What is the difference between junk dimension and degenerated dimension?
Where the cache files stored?
What is surrogate key? Where we use it explain with example?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
How to generate iqd file from framework manager?