Interested to Buy Any Domain ? << Click Here >> for more details...
Explain about derived tables?
- 2 Answers
- 8935 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinay
derived tables are logical tables in the universe. to
reduce the query complexity and better query performance or
complex querys we write in derived tables. derived tables
are nothing but sql queries. thease tables can be used in
prompts...
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / srini
Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;
| Is This Answer Correct ? | 1 Yes | 0 No |
Explain what are the steps to do to use alerts in bo?
how do u implement dense rank in a report?
WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?
What is thumbnail?
When we can use multiple sql statement for each measure? and multiple sql statement for each context?
Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?
Explain about a task that really tested your analytical abilities?
Explain what is the difference between slice and dice and cross tab report?
Is it mandatory to give a cardinality ? If cardinality is not given what will happen?
How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.
Teradata 
