what is the difference btween olap and oltp?
Answer Posted / madhusudana rao
OLTP:
# OLTP means Online Transactional Processing, data comes
from different sources
# OLTP is normalized(3NF)
# it's used to stored the current transactional data
# it's store the less no of data
# here we will perform the DML operations
(INSERT,UPDATE,DELETE)
# performance is very fast
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
explain in detail about type 3?
What is difference between custom hierarchy and report based hierarchy?
How were the reports scheduled and how to resolve unexecuted documents?
Can anybody tell me what are the tuning problems?
What is the difference between user and versatile user?
How we drill up week to month?
What we need to discuss with designer before starting the universe designing.
Did you face any problems while creating reports? Name? Solutions?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
Explain when to use local filter and when to use global filter?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
In banking domain how many Fact tables,Dimension table are present?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What is Indexing? how did u implement indexing?