Explain me What are Data Marts?
Submitted by: AdministratorData 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online General Datawarehousing Job Interview Questions And Answers
Top General Datawarehousing Questions
| ☺ | What is SCD1 , SCD2 , SCD3? |
| ☺ | What is ODS? |
| ☺ | Explain piconet? |
| ☺ | Explain the Difference between OLTP and OLAP? |
| ☺ | Explain What are the Different methods of loading Dimension tables? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
