Interested to Buy Any Domain ? << Click Here >> for more details...
What is an OLTP (Online Transaction Processing) System?
- 4 Answers
- 9316 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 a relationship?
what is a hot file, why we need in datawarehousing, where we used in general
Suggest a good author for hyperion in data warehousing?
Tell me the Top 10 features of oracle that supports datawarehousing.
Difference between cold fusion 5 and cold fusion mx 6?
How to answer the question how many fakt table in your datawarehouse and what size it have?
How many project sources we can create in metadata?
What are data modeling and data mining? Where it will be used?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What are aggregate tables and aggregate fact tables?
Can we have more than one time dimensions in a Schema(Star or Snowflake)
Teradata 
