Interested to Buy Any Domain ? << Click Here >> for more details...
What is an OLTP (Online Transaction Processing) System?
- 4 Answers
- 8898 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 |
Explain why denormalization is promoted in universe designing?
Do you view contain data?
Explain what is the difference between power center & power mart?
What are the steps involved in designing a fact table?
Start a batches with in a batch?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Explain which are the olap tools available that are supported by oracle?
Which columns go to the fact table and which columns go the dimension table?
What is DTM session?
What are the types of partitioning?
What is Operational Data Store?
Teradata 
