Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 49277 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / nagesh dusi
datawarehouse is the collection of different subject related
information in the organization like
finance,hr,sales,purchases.datawarehouse is for analysis
purpose.we can read the data only,once the data is stored we
can not change(until the client athorization).Data warehouse
will store the historical data for analysis purpose and
Reporting purpose.To construct the data ware house it will
take 1 to 2 years.
In data mart subject related information is stored.data mart
is the part of the dataware house.it explain the information
about the particular subject. we can make changes with
insert,update and delete options.Most of the companies will
prefer Data Mart only for there organizations.Data Mart is
used to Record the current transactional record purpose. To
construct the Data Mart it will take 6 months to 8
months.organizations firstly prefer to construct there
typical area of the business first on this data mart and
based on the requirement of the organization they will
implement remaining data marts
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is your spectra photometer working principles?
What is the goal of optimizer?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What are the main steps to build the data warehouse?
what are the all possible features supported modify stage?
For faster process, what we will do with the universe?
What is the working process for application.cfm?
Explain dimension table ?
What is the difference between view filter and report filter?
Tell me what is full load & incremental or refresh load?
in general which algorithms for used?
What does level of granularity of a fact table signify?
Explain why should you put your data warehouse on a different system than your oltp system?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
