what is the difference btween olap and oltp?
- 6 Answers
- 15897 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / jansi
OLAP - Online Analytical Processing, which deals with
analysis of data. It has to deal with historical data too (
for analysis purpose) Not updated frequently. If required
bulk update is allowed.
OLTP - Online Transactional Processing, which deals with
transactions. For e.g. withdrawals at ATM machines. It
involves many transactions. The databases have to be updated
more frequently after the successful completion of a
transaction.
| Is This Answer Correct ? | 26 Yes | 3 No |
Post New Answer View All Answers
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
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 difference between zabo and webi?
How can you first report in Business Objects by using broadcast agent?
Differences between business objects and web intelligence reports?
Explain in detail about type 2(scd),
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
what is xcelsius architecture?
Explain how many universes can be created in a project?
What we need to discuss with designer before starting the universe designing.
Explain how to execute the plsql procedure from the report by clicking with mouse?
What would you consider as your biggest achievement and why?
Can we create universe with no cache??
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
