Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48782 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 are components of reportnet?
Explain some of modeling tools available in the market?
What is the difference between connected and unconnected stored procedures?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
What are parallel querys and query hints?
Explain what are the advantages and disadvantages of reporting directly against the database?
Can we start and stop single session in concurent bstch?
How many project sources we can create in metadata?
How to join 3 database like flat file, oracle, db2 in informatrica?
What we will do with the universe for faster process?
Explain vldb?
Explain what is partitioning? What are the types of partitioning?
Explain what is a view as it relates to system modeling?
Why should we use data ware housing and how can you extract data for analysis with example?
Explain what are the possible data marts in retail sales?
