Explain about derived tables?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what sort of existing documents should business analysts refer to when starting on a new project?

782


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

784


is it possible to export the webi reports to crystal reports?with out using businessview?

2028


What is the difference between slice and dice and cross tab report?

823


Can we create universe with no cache??

2161


How to generate the report from excel sheet?

831


What is the functional & architectural differences between business objects and web intelligence reports?

2138


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1786


Explain what would you consider as your biggest achievement and why?

754


Can anybody tell me what are the tuning problems?

1785


What is aggregate table and aggregate fact table ... Any examples of both?

796


Explain what three things do you consider to be the most important factors for a manager?

746


Which command using Query Analyzer will give you the version of SQL server and operating system ?

4509


What is thumbnail?

735


Can you please send me the migration related issues .

1838