What is an OLTP (Online Transaction Processing) System?
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 |
Can you brief about the Data warehouse project you worked on?
What is an OLTP (Online Transaction Processing) System?
What are the various methods of getting incremental records or delta records from the source systems?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
How Materialized Views are linked with Oracle DataWare house?
Explain the importance of data warehouse?
What are loops in Datawarehousing?
Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends
What are cursors?
what are the all possible features supported modify stage?
How to pivot data using informatica when you have variable amount of pivot rows?
How to stop a batch?