Explain about derived tables?

Answers were Sorted based on User's Feedback



Explain about derived tables?..

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

Explain about derived tables?..

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

Post New Answer

More Business Objects Interview Questions

How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.

1 Answers   Cognizant, WinAlliance,


Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,


Who launches the supervisor product in Business Objects for first time?

2 Answers  


what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

2 Answers   IBM,


Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

4 Answers   TCS,






IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

3 Answers   Accenture,


What are the errors u have faced in creating reports in business objects and explain some?

3 Answers   TCS,


if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  


What are the steps to do to use alerts in bo?

0 Answers  


Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?

1 Answers  


I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps

17 Answers   IBM,


HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE

2 Answers  


Categories