Interested to Buy Any Domain ? << Click Here >> for more details...
What are Data Marts?
- 2 Answers
- 5716 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vasu bathula
DataMart is a subset of data warehouse and it is supports a
particular region, Business unit or business function.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
What is an er diagram?
Explain what are the mapping paramaters and maping variables?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are aggregate transformation?
What are the different types of fact tables used in data warehousing?
What are the differences between datamart vs. Reporting cube?
Explain when do we analyze the tables? How do we do it?
What is Snow Flake Schema design in database?
What are non-additive facts in detail?
Explain why should you put your data warehouse on a different system than your oltp system?
What is the difference between olap and oltp?
Explain me what are data marts?
Teradata 
