What is the difference between a data warehouse and a data mart?
Answer Posted / seetha
data mart is a subset of datawarehouse
data warehouse is a collection of hetrogeneous data
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Could any one explain me how to create cascading prompts?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is an error log table in informatica occurs and how to maintain it in mapping?
What are templates in which way it is help full?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
Explain reference cursor?
Explain some of modeling tools available in the market?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
How to create prompts in report net?
What is drill-through?
What are data validation strategies for data mart validation after loading process?
What are the main steps to build the data warehouse?
Explain why should you put your data warehouse on a different system than your oltp system?
How do you create surrogate key using ab initio?
What is the difference between mapping parameter & mapping variable in data warehousing?