Data Architect Question:

Tell us what is data mart?

Data Architect Interview Question
Data Architect Interview Question

Answer:

Data marts are generally designed for a single subject area. An organization may have data pertaining to different departments like Finance, HR, Marketing etc. stored in data warehouse and each department may have separate data marts. These data marts can be built on top of the data warehouse.


Previous QuestionNext Question
Can you distinguish between OLTP and OLAP?Explain me what is a role-playing dimension?