Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference btween olap and oltp?
- 6 Answers
- 17684 Views
- CTS, Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / anand
OLTP
* Is the E-R modleling,there are more concurrent users,
* It contains normalized tables so there is no redundancy.
* More tables,Joins and less Indexes,
* It stores daily transactional data
* It stores very less data
* It contains mainly current data
* INSERT,UPDATE,MODIFY can be applied on OLTP.
* Performace will be high
OLAP
* It is the Dimensional Modeling
* It contains Denormalised tables there will be redundancy.
* Less tables,Joins and more Indexes
* It stores operational data
* It contains Historical and Present data
* only SELECT clause is applied on OLAP
* It stores very Huge data
* Performance will be low compared with OLTP
| Is This Answer Correct ? | 27 Yes | 0 No |
Post New Answer View All Answers
can anybody tell me about complicated object you have created
Explain what are the measure objects?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
is it possible to export the webi reports to crystal reports?with out using businessview?
How would you format some text using css to be verdana and bold?
What we need to discuss with designer before starting the universe designing.
Difference between zabo and webi?
What is object stores?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
what is xcelsius architecture?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
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
Explain is there any other repository domains rather than universe, security, document?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
What Is Snow Flake Schema?
