Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48193 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
How to provide security in frame work manager for a query subject?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain the hierarchies level data warehousing.
Could any one explain me how to create cascading prompts?
How to import vsam files from source to target. Do we need a special plugin?
What are the data types present in bo? What happens if we implement view in the designer n report?
What are the reasons to use a chameleon method in data warehousing?
Explain multivalued dependency?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
Explain when do we analyze the tables? How do we do it?
What is meant by metadata in context of a data warehouse?
Explain grouped cross tab?
Explain how are the dimension tables designed?
what is difference between drill & scope of analysis?
Explain if a flat file cotains 1000 records how can I get first and last records only?
