What is the definition of derived table ?
- 2 Answers
- 8515 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
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 steps to be taken to schedule the report?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
How to generate the report from excel sheet?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
what is xcelsius architecture?
What is the difference between condition & filter?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
any difficulitis have you phase while creating bo reports and how did u solve it
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What Is The Difference Between Oltp And Olap?
can anybody tell me about complicated object you have created
How to restrict password to a user while sending a document in .pdf format
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
