7.what is data mart?
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 |
What are the traps ? What are the disadvantages of traps?
How can we use multiple data providers in a single report in business objects?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
in sap bi we have wad, then why we go for sap bo
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 use of BO SDK?
What is scope of analysis ?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
i want to hide a chart in reporting level? i want to hide a prompt in designer level?
How to Avoid the overlaping the blocks in WEBI.
If the Hi-rarchies are not defined in the universe level .Is it possible to do in the report level?
What is the Difference b/w Server based Ranking and normal Ranking?