Interested to Buy Any Domain ? << Click Here >> for more details...
What is an OLTP (Online Transaction Processing) System?
- 4 Answers
- 9179 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 hot file, why we need in datawarehousing, where we used in general
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?
What is the difference between snowflake and star schema?
What is a Data Warehouse?
4.Explain Snowflkeschema ?
6 Answers EDS, HCL, IBM, iFlex, TCS,
Explain how many ways you create ports?
What is the working process for application.cfm?
Explain what is the difference between datawarehouse and bi?
How can Oracle Materialized Views be used to speed up data warehouse queries?
How to calculate fact table granularity?
what is indexing ? what are different types of indexes supported by oracle ?
what is the diffrence between psa and idoc
Teradata 
