what is the difference between OLTP database and data
warehousing database?
Answer Posted / sanchari chowdhury
Records in a OLTP database can be updated or modified or
deleted. However,the same is not possible in DW.
OLTP database is used for transactional purposes e.g. day-
to-day sales or finance and DW is used for analytical
decisions.DW is mainly used for business decisions to
ensure stability of the organisation by curbing the
possible failures. This is possible because it contains the
historical or the archived data for analysis.
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
how do u set partition points in the mapping?
Difference between flat files and relational sources?
Explain etl mapping sheets?
Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to youÂ
What is etl tool in hadoop?
what are Lookup caches options? Including persistent caches.
what is different between sequential batch and concurrent batch and which is recommended and why?
what is the main role of FI on business
Explain do we need an etl tool? When do we go for the tools in the market?
tell me few points when u become TL
What are the types of Data Warehouse applications?
List few etl bugs?
Define slowly changing dimensions (SCD)?
What is initial load and what is full load?
What is abap? What are idocs?