What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 23889 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 |
8. How much supervision have you typically received in your previous job?
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
How to change font color of values in hyperlinked columns?
Explain what are the steps to do to use alerts in bo?
What is domain? How many are there in a basic setup? What are they?
How to change the order of prompts in universe?
What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?
What is the difference between Boxir2 and Boxir3?
what is the difference between bo and cognos?
Teradata 
