Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 18215 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
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
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.
Explain what three things do you consider to be the most important factors for a manager?
how to create metric universe ?
Explain when to use local filter and when to use global filter?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
What is object stores?
Explain about a task that really tested your analytical abilities?
what are the tables used in health care domain project and columns used in report?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
what will be the contents for a functional requirements specifications
Explain which versions are used in the bo dashboard work?
How to generate the report from excel sheet?
What is the difference between user and versatile user?
