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 |
What is crass reference table?
What is the difference between olap and oltp?
what are the all possible features supported modify stage?
Compare and contrast aggregates & indexes
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is Time Series algorithm in data mining?
What's a Cube in Rolap?
Explain in simple terms, the concept of Data Mining.
What is difference between Mapplet and reusable transformation?
Explain me what are conformed dimensions?
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?