Answer Posted / swamy.l.n
1.A DATA MART IS SUBJECT OF ENTERPRICE DWH.
2.A DATA MART IS SUBJECT ORIENTED D-BASE WHICH SUPPORT THE
BUISINESS NEEDS OF MIDDLE MANAGEMENT OR INDUISUAL
DEPORTMENT IS IN ENTERPRICES.
3.A DATA MART IS ALSO KNOWN AS "HIGH PERFORMENCE QUERY
STRUCTURE".
DATA MARTS ARE TWO TYPES:-
1.DEPENDENT DM:-
IN A TOP-DOWN DWH APPROACH A DM DEVELOPMENT DEPENDED
UPON ENTERPRISE DWH.
2.INDIPENDENT DM:-
IN A BOTTOM-UP DWH APPROACH DM DEVELOPMENT IS IN
DEPENDENT UPON ON INDIPENDENT DWH.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is load manager?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
What is the limit to the number of sources and targets you can have in a mapping?
What is perform recovery?
What are the different types of fact tables used in data warehousing?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What is many-to-many dimensional model in datawarehousing ?
How to create different types of templates?
What is metadata in context of a datawarehouse and how it is important?
What is vdl (view definition language) explain?
Explain what are slowly changing dimensions?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain what are the various methods of getting incremental records or delta records from the source systems?
Explain a linked cube?
List down some of the real time data-warehousing tools?