What is the difference between a W/H and an OLTP application?

Answer Posted / bindu

W/H maintains subjectoriented,timevariant,histrorical data.
where as OLTP apllications maintains current data, and it
gets updates regularly. ex:ATM machine,Railway reservations
etc.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are necessary tasks to install reportnet software?

477


What is surrogate key? Where we use it? Explain with examples.

536


I know of using applysimple, but there are other ways too?

554


How to create different types of templates?

508


What is core dimension?

545






What should I have in mind when building olap solution from scratch?

523


Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

508


Define data warehouse?

546


Start a batches with in a batch?

545


Explain are data mart and dwh normalized or denormalized? Do both of them exist in

580


What are different deliverables according to phases?

2841


What are the steps to build the datawarehouse?

575


Explain why fact table is in normal form?

534


Suppose we want to display zero when null values coming to report how can we do that?

522


What is load manager?

563