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
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
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 which versions are used in the bo dashboard work?
what are the tables used in health care domain project and columns used in report?
Can you please send me the migration related issues .
Explain what is aggregate table and aggregate fact table ... Any examples of both?
What is the difference between slice and dice and cross tab report?
What is the difference between datawarehousing and businessintelligence?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain in detail about type 2(scd),
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
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
how get the grand total in master-detail report?
Explain is data mart?