General Datawarehousing Question:
Explain me What are Data Marts?
Answer:
Data Marts are designed to help manager make strategic decisions about their business.
Data Marts are subset of the corporate-wide data that is of value to a specific group of users.
There are two types of Data Marts:
1.Independent data marts ? sources from data captured form OLTP system, external providers or from data generated locally within a particular department or geographic area.
2.Dependent data mart ? sources directly form enterprise data warehouses.
Data Marts are subset of the corporate-wide data that is of value to a specific group of users.
There are two types of Data Marts:
1.Independent data marts ? sources from data captured form OLTP system, external providers or from data generated locally within a particular department or geographic area.
2.Dependent data mart ? sources directly form enterprise data warehouses.
| Previous Question | Next Question |
| What is ODS? | What is a level of Granularity of a fact table? |