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
Explain the differences between normalizer and normalizer transformation?
How to limit the max no of rows retrieved in the report?
What is normalization, first normal form, second normal form, third normal form?
What is Cognos script editor?
What is the difference between star and snowflake schemas?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
I have two universes created by two difference database can we join them in designer & report level? How
What are steps we have to follow in designing the userfriendly universe?
Which are the olap tools available that are supported by oracle?
Explain difference between view and materialized view?
What are the different types of schemas used in data warehousing?
Why null values are mapped as 0 in fact tables?
What is index awareness in universe?
What are components of reportnet?
Explain what is the advantages data mining over traditional approaches?