BO Designer - Universe Parameters

GeekInterview.com > Interview Questions > Data Warehousing > BO Designer

Go To First | Previous Question | Next Question

BO Designer | Question 116 of 117

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

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

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

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

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 | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank