what is the difference btween olap and oltp?
Answer Posted / madhusudana rao
OLAP:
# OLAP means Online Analytical Processing
# OLAP is denormalized
# it's containes current&previouse data and used for the
analytical purpose
# perfprmance processing is slow compare with OLTP
#it is used to store the large data
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Can you please send me the migration related issues .
What is the difference between condition & filter?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is report template in b.o?
Explain how many universes can be created in a project?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Difference between zabo and webi?
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.
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
can anybody tell me about complicated object you have created
What is thumbnail?