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 definition of normalized and denormalized view?
Explain a mapping, session, worklet, workflow, mapplet?
Explain what is the difference between a primary and secondary actor in use case modeling?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are the different types of scd's used in data warehousing?
What are the various transformation available?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What is the difference between drill through and masterdetail reports?
Explain can a dimension table contains numeric values?
What is the difference between olap and datawarehosue?
What are situations where snowflake schema is better than star schema when the opposite is true?
How can we run the graph?
What is the metadata extension?
What are the different models used in cluster analysis?