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 the 4 + 1 view model as it relates to system modeling?
Explain the main differences between star and snowflake schema?
Explain some of modeling tools available in the market?
What is a real-time data warehouse?
What is the definition of cube in datawarehousing?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is latest version of power center / power mart?
What is dimension modeling?
What are the various methods of getting incremental records or delta records from the source systems?
What are the difference between snow flake and star schema?
Explain about core dimension,
What is cfapplication tag?
What is meant by metadata in context of a data warehouse and how it is important?