Interested to Buy Any Domain ? << Click Here >> for more details...
Aliases and Contexts Which once will give the better
performence when resolve the loops?
- 3 Answers
- 8859 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / narender reddy
Join path: a join path is a series of joins that a query can use to access data in the tables linked by the joints. Join path problems can arise from the limited way that lookup and fact tables are related in a relational data base. The three major join problems that you encounter when designing a schematic are the following:
1. Loops
2. Chasm traps
3. Fan traps
Queries can return incorrect results due to the limitations in tha way that joins are performed in relational databases.
Loops: joins between tables form a continues path
Solved by: shortcut join(3 tables), aliases( more than 3 tables with one fact table), context( more than 3tables with more than one fact table),
Chasm traps: many to one joins from two fact tables converge on a single lookup table. This type of join convergence can lead to a join path problem called as a chasm trap.
Solved by: context, creating multiple SQL statements for each measure, creating multiple universes( webi only),
Fan traps: a one to many join links a table which is in turn linked by a one to many join. This type of serial many to one joins can lead to a join path problem called a fan trap.
Solved by: alias, using multiple SQL statements for each measure, creating the context using the alias.
Aliases: An alias is a table that is a exact duplicate of the original table, with a different name. The data in the table is exactly the same as the original table. Using aliases resolve loops and fan traps.
Context: context is a collection of joins which provide a valid query path for user to generate SQL. Using contexts we can resolve loops and chasm traps and assisting in some solutions of fan traps.
-------- when we use alias to resolve the loop we are using extra duplicate table, if we have more tables in schema it will decrease the performance so alias always decrease the performance compair to context.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is a bo repository?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
When we use aggregate awareness function in designer?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain what is aggregate table and aggregate fact table ... Any examples of both?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
How to open a universe with out using the Designer ??
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
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.
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Can Bo generates the Report from the cubical data Explain?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain what is the difference between slice and dice and cross tab report?
What we need to discuss with designer before starting the universe designing.
