what is the difference btween olap and oltp?
Answer Posted / balaji
OLTP
• Current data
• Short database transactions
• Online update/insert/delete
• Normalization is promoted
• High volume transactions
• Transaction recovery is necessary
• only one record is processed at a time
• data is present in 2d format
OLAP
•
• Current and historical data
• Long database transactions
• Batch update/insert/delete
• Denormalization is promoted
• Low volume transactions
• Transaction recovery is not necessary
• group of records processed at a time
• data is present in multi dim format
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
what is xcelsius architecture?
Explain what three things do you consider to be the most important factors for a manager?
Difference between b.o 5.1 and 6.1b?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Explain about a task that really tested your analytical abilities?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
explain in detail about type 3?
Explain is data mart?
Can we configure two instances of CMS pointing to two different CMS system databases?
What is top business?
what is universe null
What is the difference between condition & filter?