Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 18010 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
Explain how to schedule the report in b.o?
What are the steps to do to use alerts in bo?
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?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What are all difference between business objects 6.5 and xi r2?
what are the tables used in health care domain project and columns used in report?
Can anybody tell me what are the tuning problems?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
How would you format some text using css to be verdana and bold?
how to create metric universe ?
what is xcelsius architecture?
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.
