what is the difference btween olap and oltp?
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
What Is The Difference Between Oltp And Olap?
What is the profile and package?
How to open a universe with out using the Designer ??
How to restrict password to a user while sending a document in .pdf format
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
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?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
When we use aggregate awareness function in designer?
explain in detail about type 3?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Explain in detail about type 2(scd),
Explain about a task that really tested your analytical abilities?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain how to schedule the report in b.o?