What is an OLTP (Online Transaction Processing) System?

Answer Posted / samir kumar sahoo

OLTP stands for OnLine Transaction Processing . It uses
database tables(Fact and Dimention tables) to enable
multidimentional viewing, analysis and querying of large
amount of data.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why should you put your data warehouse on a different system than your oltp system?

498


What are snapshots? What are materialized views & where do we use them?

521


Explain some of modeling tools available in the market?

524


Where the cache files stored?

543


Explain what is partitioning? What are the types of partitioning?

511






Where the applications and where ware house management system is used?

534


How to export mappings to the production environment?

502


What are the advantages of query studio compared to report studio?

499


Explain what is the metadata extension?

577


Explain the different types of data warehousing?

567


What are the data types present in bo?

570


Describe the differences between a data warehouse and data mart.

504


How to test report in reportnet?

563


What is index awareness in universe?

573


Is there any default username & pwd for bo designer & supervisor?

568