Answer Detail: RE: Universe Parameters

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

Print |

Question: Universe Parameters

Answer: What are Universe Parameters? What does the Parameters tab in Universe Parameters indicate?

October 10, 2008 05:49:25	#4
sagarikaka	Member Since: April 2008 Total Comments: 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.