GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  BO Designer
Go To First  |  Previous Question  |  Next Question 
 BO Designer  |  Question 116 of 117    Print  
Universe Parameters
What are Universe Parameters? What does the Parameters tab in Universe Parameters indicate?


  
Total Answers and Comments: 4 Last Update: October 30, 2008     Asked by: sagarsil 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: sagarikaka
 
The Parameter tab in the universe indicates list of SQL parameters that can b set to optimize SQL generation.The parameters file is still used for many RDBMS specific SQL and connection parameters. following are few dynamic SQL generation parameters available to the universe.
ANSI92
AUTO_UPDATE_QUERY
BLOB_COMPARISON
BOUNDARY_WEIGHT_TABLE
COLUMNS_SORT
COMBINES_WITH_SYNCHRO.......etc.

Above answer was rated as good by the following members:
Mkhan79
July 22, 2008 16:10:44   #1  
Priyank Bhayani Member Since: July 2008   Contribution: 2    

RE: Universe Parameters
Universe Parameter are
name of the universe connection size rights and security implmentation.

 
Is this answer useful? Yes | No
August 14, 2008 13:00:44   #2  
sai724 Member Since: August 2008   Contribution: 2    

RE: Universe Parameters
Universe connection (3 different types) Universe summary Strategies either built-in or external result set limit and execution time controls query and SQL generation paths and finally SQL generation parameters e.g: auto_update_query etc;
 
Is this answer useful? Yes | No
October 30, 2008 05:00:23   #3  
sagarikaka Member Since: April 2008   Contribution: 7    

RE: Universe Parameters
Universe Parameters are definitions and restrictions that you define for a universe that identify universe and its database connections specify type of queries that can b run using the universe and set the controls on the use of system resources.Universe Parameters are defined from the Universe parameters dialogue box (File>Parameters} when you create a universe.The database connection is only parameter that you must manually select or create when you create a new univers.
 
Is this answer useful? Yes | No
October 30, 2008 05:49:25   #4  
sagarikaka Member Since: April 2008   Contribution: 7    

RE: Universe Parameters
The Parameter tab in the universe indicates list of SQL parameters that can b set to optimize SQL generation.The parameters file is still used for many RDBMS specific SQL and connection parameters. following are few dynamic SQL generation parameters available to the universe.
ANSI92
AUTO_UPDATE_QUERY
BLOB_COMPARISON
BOUNDARY_WEIGHT_TABLE
COLUMNS_SORT
COMBINES_WITH_SYNCHRO.......etc.

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape