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                      
tip   To Refer this Site to Your Friends   Click Here
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 ?    0 Yes 0 No
Prasanna.ramesh1
 

 
 
 
Other Business Objects Interview Questions
 
  Question Asked @ Answers
 
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important Zylog4
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how Keane-India-Ltd2
how do u implement dense rank in bo reports? CTS2
what do u mean by variable functions ?  1
what is the source for metrics?  1
what is drill down? TCS5
HOW TO SPOT A HIERARCHY? TCS1
What are steps to be taken care to create a good Universe?  1
What is Complex Reports? TCS2
how to hide the prompts? TCS4
WHAT IS ROW LEVEL SECURITY IN BO? Wipro1
How will you know the version of Bo using designer?  3
IN BOXIR2 creating universe by using Designer and Business View. What is the difference b/t two? TCS3
What is a loop? How can we overcome?  3
what is master-detail report TCS2
how to make a report avilable to other users?  1
what is fantrap?  2
I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance TCS2
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?  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
 
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