Data Mart and Types of Data Marts in Informatica
Data mart can be defined as the subset of data warehouse of an organization which is limited to a specific business unit or group of users. It is a subject-oriented database and is also known as High Performance Query Structures (HPQS).
Data marts are of two types – Dependent and Independent.
Dependent Data Mart – This data mart depends on the enterprise data warehouse and works in top-down manner.
Independent Data Mart – This data mart does not depend on the enterprise data warehouse and works in bottom-up manner.
Benefits of Data Marts
- Allows the data to be accessed in lesser time
- Cost-efficient alternative to the bulky data warehouse
- Easy to use as designed according to the needs of specific user group
- Fastens the business processes.