7.what is data mart?
- 7 Answers
- 13753 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 |
Explain the BO Developer WORK FLOW?
Explain about a task that really tested your analytical abilities?
what is aggregate navigation?
3 Answers Countrywide, CTS, HCL,
what is dashboards? what is metrics?
When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?
HOw do u migrate from old version to the new version?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
How to Implement the the Built-in Strategy Script in BO Designer?
1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?
Teradata 
