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 Users and User groups?
How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible
Explain the difference between union and group?
When we are going for Shortcut join and why.
What is the difference b/w breaks and sections
can BO generate reports with out CUBICAL data to repository?
Can we link the Universes from two different sourcess?Explain?
How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.
Tell me the difference between cmc and cms?
if the project is assigned for you and the client said yo wait for a month,What will you do in that time?
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
What are alertors in Business Objects?