7.what is data mart?
- 7 Answers
- 13422 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 |
I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process
Explain which versions are used in the bo dashboard work?
Can we create universe with no cache??
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What Is The Difference Between Oltp And Olap?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
how to test reports in businessobjects?
in sap bi we have wad, then why we go for sap bo
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
What is #refresh,#hash,#Comupation error and How to resolve #refresh,#hash error.
What are the different types of connections?Explain?
Teradata 
