What are Data Marts?
- 2 Answers
- 5315 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 |
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Start a batches with in a batch?
What are the various methods of getting incremental records or delta records from the source systems?
Explain the data type of the surrogate key?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Explain the versions of reportnet?
What is crass reference table?
What is the advantages data mining over traditional approaches?
Can any one explain the hierarchies level data warehousing.
Explain what are slowly changing dimensions?
What are the approaches used by optimizer during execution plan?
Teradata 
