What is an OLTP (Online Transaction Processing) System?
- 4 Answers
- 7627 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep.t nizamabad
1.oltp stands for online transaction process
2.transactions will be done in this process
3.this should be use by clerical users
4.IT CONTAINS ONLY CURRENT DATA
5.WE CAN STORE THE DATA UPTO ONE YEAR
6.THE DATA TYPE IS VOLATILE
7.IT CONTAINS THE DETAILED DATA
8.ROUTINE ACTIVITIES ARE IMPLEMENTED
9.ONE RECORD ONLY PROCESSED AT A TIME
10.INSERT,UPDATE,DELETE OPERATIONS ARE USED
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is meta data and system catalog?
Explain the definition of normalized and denormalized view?
What are various warehousing tools?
Why is business intelligence (bi) important in data warehousing?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Which component has onread method and what it is used for?
What is conformed fact?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
can anybody mail me the FAQS for hyperion essbase amd planning
Explain the difference between keylokup and joiner?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
How to export mappings to the production environment?
Explain what are the basic needs to join two sources in a source qualifier?
Explain some of modeling tools available in the market?
