When we go for OLAP , and When we go for OLTP for
generating the reports ?
Answers were Sorted based on User's Feedback
Answer / kkreddy
When we need more historical data we will opt for OLAP. And
when we need the real time data or current data we will opt
for OLTP.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / mallikarjuna reddy
OLTPs are the original source of the data.OLAP data comes
from the various OLTP Databases
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / jay
If we need most recent updated data in reports we go for OLTP
or else we go for OLAP.
| Is This Answer Correct ? | 4 Yes | 3 No |
What Is Snow Flake Schema?
What are the general issues in migration process?
Explain what are the measure objects?
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...
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
Shall we connect to the oltp systems directly .,
How you get the requirement from client?
Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?
what are the differences between web intelligence reports and crystal reports ?
how to do Ad-hoc reporting ?
how to solve #multivalue, #syntax, #error. iwant complete solution process in practical wise?
What is the difference between Thin client & thick client?