What is the definition of derived table ?
Answers were Sorted based on User's Feedback
Answer / subramanyam
Derived table is nothing but logical table like view.it
doesn't carry out any data in the database.It is the
function in the designer. You can use the view as the table
in the universe design and you can create the class objects
and conditions based on that derived table.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
Hi I am starter in BOXIR2.CAn anyone plz tell me the user identification details to be entered at the time of login to designer/deski
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Hi, How to navigate one report to another report in webi? Thanks in Advance
What is the functional & architectural differences between business objects and web intelligence reports?
Explain what task is 98% of the required work of a business analyst?
Have you worked with multiple data sources? If yes. How do you link them?
How to restrict password to a user while sending a document in .pdf format
how to do Ad-hoc reporting ?
What is ment by For each For all function. In which case we use the option in BO?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
how to link 3 fact tables