why we are using derived tables ?how it will help?
Answers were Sorted based on User's Feedback
Answer / mayur
hi,
see i would like to answer it through on example:
consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..
now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...
& even a complex sql is effectively implemented...
finally this will enhance ur performance & a effective development logics ....
Is This Answer Correct ? | 0 Yes | 4 No |
Instead of Aggregated table we use the Derived table.
Aggregated table will be created by ETL people, for
summarized columns we use Aggregated table.
Is This Answer Correct ? | 0 Yes | 9 No |
what is the difference between breaks and sections?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
What is the link option in the reporting Environment?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
How can we improve performance?
every alternative row should be hilighted ? how u can ?
How to get two dimension objects in a same block which are comming from two different contexts ?
Pls Explain about the different between 6.5 & Xi R2
am a fresher hw to get real time experience?
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
What is the purpose of @aggregate aware function?please draw, how you use the @aggregate aware function
6 Answers Cap Gemini, Deloitte,
CAN A REPOSITORY CONTAINS REPORTS?