Aliases and Contexts Which once will give the better
performence when resolve the loops?
Answer Posted / raj
*If a loop contains only one lookup table then the loop can be resolved by detecting the alias.
*If a loop is having 2 or more fact tables (multiple fact tables) then the loop can be resolved by
detecting context.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what will be the contents for a functional requirements specifications
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
Difference between b.o 5.1 and 6.1b?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
What is the difference between the public object&schema object?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Explain what is the difference between slice and dice and cross tab report?
How we drill up week to month?
How were the reports scheduled and how to resolve unexecuted documents?
Explain how to schedule the report in b.o?
In banking domain how many Fact tables,Dimension table are present?
What is Indexing? how did u implement indexing?
Explain is data mart?
Explain in detail about type 2(scd),
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?