What is data mart in data warehouse?



What is data mart in data warehouse?..

Answer / Thakur Rajkumar Singh Rana

A Data Mart is a subset of a Data Warehouse designed to meet the specific needs of a particular department or business unit within an organization. Data Marts are created by filtering, aggregating, and summarizing data from the Data Warehouse, making it easier for users in those departments to access and analyze the information relevant to their roles.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Warehouse General Interview Questions

What is crass reference table?

1 Answers  


What is the difference between olap and oltp?

1 Answers  


what are the all possible features supported modify stage?

1 Answers  


Compare and contrast aggregates & indexes

1 Answers   IBM, TCS,


How to allow a dynamic selection of a column for a measure in a chart,without using variable?

1 Answers  


What is Time Series algorithm in data mining?

2 Answers  


What's a Cube in Rolap?

2 Answers   Oracle,


Explain in simple terms, the concept of Data Mining.

3 Answers  


What is difference between Mapplet and reusable transformation?

3 Answers   UST,


Explain me what are conformed dimensions?

1 Answers  


Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

1 Answers   Principal Finance, PT Metalogix Infolink Persada,


What are the main steps to build the data warehouse?

1 Answers  


Categories