What are Data Marts?
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 is a star schema?
What are the various file formats involved in reportnet?
what type of raid setup would you put your tx logs?
Where the data cube technology is used?
What is conformed dimension?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
What's a Cube in Rolap?
What needs to be done when the database is shutdown?
What is the "junk dimension"? Give with examples?
What is data warehosuing hierarchy?
What is cost benefit analysis (cba)?