What is an OLTP (Online Transaction Processing) System?
Answer Posted / samir kumar sahoo
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 |
Post New Answer View All Answers
What is metadata in context of a datawarehouse?
Compare and contrast aggregates & indexes
What is Star Schema?
Explain degenerate dimension table?
What is data type of the surrogate key?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
Explain the difference between dw and bi?
ware house management system is used?
How many types of facts and what are they?
Whether dimension table can have numeric value?
Explain what are components of report studio?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What is the use of dimensional modeling in data warehousing?
What is data warehosuing hierarchy?
Briefly state different between data ware house & data mart?