What is the difference between derived table and views? which one gives better

What is the difference between derived table and views?
which one gives better performance?

Question Posted / sasi kanth

2 Answers
24830 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is the difference between derived table and views? which one gives better performance?..

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

What is the difference between derived table and views? which one gives better performance?..

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

Post New Answer

More Business Objects Interview Questions

plz tell me about BOmain key in detail?

2 Answers

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers KPIT, TCS,

what is Scope of Analysis

8 Answers TCS,

What is difference between custom hierarchy and report based hierarchy?

0 Answers

why measure objects are semantically dynamic?

1 Answers

How to create a report template BO XI R2

2 Answers Infosys, LBM,

Any one suggest me best SAP Business Objects XI Online Training institute from India

2 Answers Aetna,

How to link one location universe to other location universe

3 Answers Cap Gemini, TCS,

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers TCS,

What is package in BO

0 Answers Infosys, Saksoft,

What is meaning of fullpath client in business objects?

1 Answers Atiric Software,

Hi , can anybody explain me what is the need of migration ? and how to do it ? could plz explain me in detail?

2 Answers

For more Business Objects Interview Questions Click Here