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
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
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
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
is it possible to export the webi reports to crystal reports?with out using businessview?
What is top business?
What is package in BO
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.
Explain the data types present in bo and what happens if we implement view in the designer and report?
What sort of existing documents should business analysts refer to when starting on a new project?
What is object stores?
What are the steps to do to use alerts in bo?
explain in detail about type 3?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
When we use aggregate awareness function in designer?
What is Indexing? how did u implement indexing?