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 a real-time data warehouse?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain is fact table?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain what are conformed dimensions?
What are the steps involved in creating dimensional modeling process?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain which are the olap tools available that are supported by oracle?
What is application.cfm?
Compare and contrast aggregates & indexes
What is the use of dimensional modeling in data warehousing?
What is conformed fact?
What are session timeout and application timeout? Where we have to do this process?
What are the various methods of getting incremental records or delta records from the source systems?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?