ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  Business Objects
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question 
What is the difference between derived table and views?
which one gives better performance?
 Question Submitted By :: Sasi Kanth
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between derived table and views? which one gives better performance?
Answer
# 1		 
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 ?    2 Yes 1 No
Prasanna.ramesh1
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
in xir2 how to send reports to end user TCS2
What are the differences between webi and deski of XI R2 not the earlier versions  1
how to overcome overflow of data in a report  5
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....  2
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why? IBM2
Explain about derived tables? Cap-Gemini1
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ? BNP-Paribas1
what is the difference btween olap and oltp? Fujitsu4
how to do Ad-hoc reporting ? IBM5
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?  2
The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports  1
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report  3
how to increase the perfomance in ur designer & reporting? how to reduce the refershing time & what precations would u take ? TCS3
how many times can use the union operator in a report?  2
What is a universe? TCS6
what is tuning of business reports ? Oracle3
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?  3
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.  1
Can We customize the Business Object infoview in BO?  2
What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash iFlex2
 
For more Business Objects Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com