What is an OLTP (Online Transaction Processing) System?
- 4 Answers
- 7608 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / azhar
It stands for OnLine Transaction Processing.It is used to
record transaction.Day to Day transactions are recorded.
Data is highly Volatile.Highly Normalized.Used to generate
Information Reports.
| Is This Answer Correct ? | 8 Yes | 0 No |
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 |
Answer / 9885657928
A olap is a specification which allos the client
applications in retreiving the data from following the sources.
1.A relational data warehouse
2.Multidimentional database
| Is This Answer Correct ? | 1 Yes | 1 No |
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc
What is difference between model & package?
What are CUBES?
Explain multivalued dependency?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
How to create prompts in report net?
What is MDX?
What are necessary tasks to install reportnet software?
How to join 3 database like flat file, oracle, db2 in informatrica?
How to create diff. Types of templates?
why oracle is the best database for data warehousing?
Teradata 
