What is the definition of derived table ?
Answer Posted / kumarreddy
A derived table is one that is created on-the-fly using the
SELECT statement, and referenced just like a regular table
or view. Derived tables exist in memory and can only be
referenced by the outer SELECT in which they are created.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are the tables used in health care domain project and columns used in report?
What task is 98% of the required work of a business analyst?
What is the difference in creating filters in designer and business objects?
What is the difference between user and versatile user?
what is universe null
What Is The Difference Between Oltp And Olap?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
explain in detail about type 3?
Is there any other repository domains rather than universe, security, document?
Explain about a task that really tested your analytical abilities?
Explain in detail about type 1?
Explain the data types present in bo and what happens if we implement view in the designer and report?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes