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
Why should you put your data warehouse on a different system than your oltp system?
What are snapshots? What are materialized views & where do we use them?
Explain some of modeling tools available in the market?
Where the cache files stored?
Explain what is partitioning? What are the types of partitioning?
Where the applications and where ware house management system is used?
How to export mappings to the production environment?
What are the advantages of query studio compared to report studio?
Explain what is the metadata extension?
Explain the different types of data warehousing?
What are the data types present in bo?
Describe the differences between a data warehouse and data mart.
How to test report in reportnet?
What is index awareness in universe?
Is there any default username & pwd for bo designer & supervisor?