Interested to Buy Any Domain ? << Click Here >> for more details...
What is an OLTP (Online Transaction Processing) System?
- 4 Answers
- 9162 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 are fact, dimension, and measure?
What is the difference between constraind base load ordering and target load plan?
How can we run the graph? How can we schedule the graph in unix?
Explain what is ods (operation data source)?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What we will do with the universe for faster process?
What are Aggregate tables?
Explain why fact table is in normal form?
Explain what is power center repository?
Explain the definition of normalized and denormalized view?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What is a staging area? Do we need it? What is the purpose of a staging area?
Explain difference between data ware house & data mart?
Explain where do we use semi and non additive facts?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
