Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 17990 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
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
Explain what three things do you consider to be the most important factors for a manager?
how to create reports on screech?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
what is the difference b/w the refresh and buffered data?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Can Bo generates the Report from the cubical data Explain?
Explain what is the difference between slice and dice and cross tab report?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What is the difference between datawarehousing and businessintelligence?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
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
