Answer Posted / mark
A surrogate key from a data warehouse schema is used to join
tables both in general SQL queries against the data
warehouse and for joining tables in the universe schema.
From 6.5.1, it can also be used as part of the keys tab
within object definition to improve query performance in
certain instances.
Given that it has no meaning outside of the data warehouse
technical sphere, it should not be created as an object.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain what are the measure objects?
Did you face any problems while creating reports? Name? Solutions?
what is xcelsius architecture?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
can anybody tell me about complicated object you have created
Explain is there any default username & pwd for bo designer & supervisor?
Explain how many universes can be created in a project?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
any difficulitis have you phase while creating bo reports and how did u solve it
What is package in BO
What three things do you consider to be the most important factors for a manager?
What is the difference between business requirement document and use case document.
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com