Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 25031 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Always View is better than Derived Tabels because it
fetches the Data Directly through the Database So as per
the Performance related it's too good.
But,When we want to use @Function (@variable,@prompt) in
your Query that time it's only possible in Derived
Table,not in the VIEWS.
| Is This Answer Correct ? | 21 Yes | 0 No |
Answer / prasanna.ramesh1
a derived table is dynamic,virtual table that you create
within universe structure.it consists of set of sql
statements that you create in designer and you can use it as
a logical table to create objects.
in the derived table sql set,you can put a select statement
in place of table name in the from clause.sql set can also
contain embeded prompts and you can create joins between
embeded physical tables ,just as you can with other tables.
derived tables can be used in place of database
views,aggregate tables,lookup tables.
by using derived table we are processing load from the
report server to the database.
views are also virtual tables which are created in database
level and can make use in universe.but we can not create
them in universe structure.
| Is This Answer Correct ? | 11 Yes | 6 No |
what are the roles and responsibilities of BO Administrator ?
1 Answers OCS Infotech, TCS, Wipro,
4.what is repository? types
What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?
What are templates? Explain what you have created?
what is the diff between etl tool and olap tool
What is scope of analysis ?
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
how to solve the incompatible objects and how they are formed actually.
What Is The Difference Between Oltp And Olap?
What are the Users and User groups?
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
Is it possible to create a new calendar using BO? Ex:- Wants to create a calendar where the year starts with the 1feb - 25Feb. Next month from 26Feb - 14Mar.
Teradata 
