HI, Can any body explain me ? If we careate objects using
derived tables it will decreasess the performence? If we
are not creating the objects using the derived tables then
what is the use of having the derived tables?
Answer Posted / gowthami
In some scenario’s we cannot meet the requirement. In that case using derived table we can create own query with needed objects and can write the formula to achieve the requirement which cannot be done in general.
If there is no other way to achieve the requirement only the derived table can do. We can go for derived table. But it will decrease the performance of universe (more no of derived tables)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is object stores?
What is the dense rank?
What is the difference between datawarehousing and businessintelligence?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Which versions are used in the bo dashboard work?
Explain the difference between union and group?
What is aggregate table and aggregate fact table ... Any examples of both?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
How to execute the plsql procedure from the report by clicking with mouse?
what is document design in boxi,have u participate in that
In banking domain how many Fact tables,Dimension table are present?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Which command using Query Analyzer will give you the version of SQL server and operating system ?