7.what is data mart?
- 7 Answers
- 13036 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nareshkumar
A data mart is a subset of data warehouse that is designed
for a particular line of business such as sales, marketing,
finance, etc.
Data mart is of two types:
1) Dependent data mart, in which data can be derived from
an enterprise-wide data warehouse.
2) Independent data mart, in which data can be collected
directly from sources.
| Is This Answer Correct ? | 20 Yes | 0 No |
Answer / svs rajesh
A data mart is a particular subject oriented block of data
in the datawarehouse in the business line like production,
sales, marketing etc. they are two kinds of datamarts are
there one is independent & Dependent datamarts.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / poonam kute
Data Marts is used on a business division/department level.
A data mart only contains the required subject specific
data for local analysis.
A database, or collection of databases, designed to help
managers make strategic decisions about their business.
data marts are usually smaller and focus on a particular
subject or department. Some data marts, called dependent
data marts, are subsets of larger data warehouses. A data
mart is a simpler form of a data warehouse focused on a
single subject (or functional area) such as sales, finance,
marketing, HR etc. Data Mart represents data from single
business process.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / g.v.subramanyam
datamart is nothing but a database. it can be stored data
about the particular orginazation.
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / shaik.emambasha
sub set of datawarehouse is called data mart.
| Is This Answer Correct ? | 9 Yes | 5 No |
Answer / sid
In the industry when a organisation goes for a enterprise
wide Datawarehouse the cost involved in setting up . its
maintenance and other overheads are also associated with
it. So due to budget and time constraints some
organisations initially set up a Data Mart to facililtate
there immediate needs . These Data Marts are generally set
up at department levels and in a future date if utility
arises then datamarts across the organisation can be
integrated and a full fledged data warehouse can be formed.
In a way Data Mart is a subset of Data Warehouse.
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / sathish
"...The data warehouse is nothing more than the union of all
the data marts..."
| Is This Answer Correct ? | 0 Yes | 1 No |
Can anybody explain what mean by Database Delegated Measures?
Is it possible to create a user defined Calendar in BOXIR2? If yes, then how? Ex:- I want to create a Calendar where the year starts with the month of Feb-1. Each month is of 28 days. 1st Month as 1-feb to 28-feb. 2nd Month as 29 Feb - 21 Mar. Please help me out to get the answer....
what is the difference between bo and cognos?
What are the Users and Usergroups?
What are the different types of Filters available in BUSINESS OBJECTS?
when to go for alias and when to go for contexts
what r the advantages of creating the universe?
I have a report with some hyperlinks,any issue will i get when i migrate this report?
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
What is the difference between master-detail and Breaks?
what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance
Teradata 
