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 differences between star and snowflake schemas?
What are data modeling and data mining?
I need to set predefined condition. How I do this?
What is the difference between view filter and report filter?
The same tier?
What are the design methods of data warehousing?
Explain what is a view as it relates to system modeling?
Is union transormation is active transformation?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain how to export mappings to the production environment?
What are the advantages and disadvantages of reporting directly against the database?
What is an error log table in informatica occurs and how to maintain it in mapping?
Can you brief about the Data warehouse project you worked on?
Suppose we want to display zero when null values coming to report how can we do that?
Explain difference between snow flake and star schema.