1.WHAT IS DATA MART ?
- 5 Answers
- 9455 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Datamart is a subset of an Enterprise DataWareHouse.
Generally it contains subject oriented information means it
relates to specific deprtment like sales dept,human resource
dept,tax dept. etc of an organisation.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sudheer.r
datamart like a small datawarehouse..
its contains subset of datawarehouse..
data mart contains one particular subject oriented data..
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / arkchowdary
---Datamart-------It is a Subset of an Enterprising DWH.
------------------ Datamarts are subject oriented and
Departments Information will be there for ex
Accounts,Finanace,Products,Cosmetics................... so
like that we will tell about them.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / prodyot sarkar
A data mart is a collection of subject areas organized for decision support based on the needs of a given department. Finance has their data mart, marketing has theirs, sales has theirs and so on. And the data mart for marketing only faintly resembles anyone else's data mart.
Perhaps most importantly, the individual departments OWN the hardware, software, data and programs that constitute the data mart. The rights of ownership allow the departments to bypass any means of control or discipline that might coordinate the data found in the different departments.
Each department has its own interpretation of what a data mart should look like and each department's data mart is peculiar to and specific to its own needs. Typically, the database design for a data mart is built around a star-join structure that is optimal for the needs of the users found in the department. In order to shape the star join, the requirements of the users for the department must be gathered. The data mart contains only a modicum of historical information and is granular only to the point that it suits the needs of the department. The data mart is typically housed in multidimensional technology which is great for flexibility of analysis but is not optimal for large amounts of data. Data found in data marts is highly indexed.
There are two kinds of data marts--dependent and independent. A dependent data mart is one whose source is a data warehouse. An independent data mart is one whose source is the legacy applications environment. All dependent data marts are fed by the same source--the data warehouse. Each independent data mart is fed uniquely and separately by the legacy applications environment. Dependent data marts are architecturally and structurally sound. Independent data marts are unstable and architecturally unsound, at least for the long haul. The problem with independent data marts is that their deficiencies do not make themselves manifest until the organization has built multiple independent data marts.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gopal
Datamart is a subset of datawarehousing
some times called as a HPQS(High performance query structure)...
| Is This Answer Correct ? | 0 Yes | 0 No |
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
Explain what is the advantages data mining over traditional approaches?
How to create prompts in report net?
What is difference macros and prompts?
How did you plan your Data ware house project?
what is the difference between etl tool and olap tools
How to improve session performance in aggregator transformation?
What is the difference between power center and power mart?
Is it possible to have more than one row on the same table with the same foreign key?
Can we have multiple application.cfm file in an application?
Explain is olap databases are called decision support system true/false?
Tell me one example for multi valued dimension or bridge table?
2 Answers Accenture, CMC, IBM, Logica CMG, TCS,
Teradata 
