Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is aggregate table and aggregate fact table ... Any examples of both?
What is thumbnail?
What are the join problems comes appart from loop,chasm & fan Traps
What is report template in b.o?
What three things do you consider to be the most important factors for a manager?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
How to execute the plsql procedure from the report by clicking with mouse?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
What is the difference between slice and dice and cross tab report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
