What are Data Marts?
- 2 Answers
- 4986 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 |
I HAVE A FLAT FILE DO THE NULL CHEK AND PRIMARI KEY CHEK AND DATE VALIDITAION LOAD TO TARGET TABLE
What are algorithms provided by Microsoft in SQL Server?
What are components of report studio?
Explain hybrid slowly changing dimension?
What is the capacity of power cube?
How to stop a batch?
Where do we use semi and non additive facts?
Explain the differences between normalizer and normalizer transformation?
Explain what are the advantages of query studio compared to report studio?
Which component has onread method and what it is used for?
What is fact less fact table? Where you have used it in your project?
What are the types of SCD?
Teradata 
