can any one say me exactly when and where alias and context
are used in resolving a loop.
If possible try to give me a scenario also.
Answer Posted / vams_gk
when a schema contains a loop u should create alias
table..alias concept not only for loops.we can also use
in fantraps.
coming to context :when u run two sql statements as a
singlestatemnt we will go for context detection process.
in traps we can choose contexts.
traps are two types chasam trap and fan trap.
these traps are situvation oriented
relation betwen muliple tables like this:
--------------------------------------0-
chasam trap :1:M:1
fan trap :1:M 1:M
really if u want o see the context how to look
tools->automatic detection----.detect contexts in BO XIr2
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between user and versatile user?
how to create metric universe ?
How would you format some text using css to be verdana and bold?
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 profile and package?
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?
Explain the difference between detect alias and detect context?
how to prepare the documentation in business objects and where to get the requirement?
What is the difference between slice and dice and cross tab report?
what is universe null
explain in detail about type 3?
What is the difference between absolute and relative div positioning?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain is there any default username & pwd for bo designer & supervisor?
Explain the difference between union and group?