Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 7153 Views
- I also Faced
- E-Mail Answers
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
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Can we create universe with no cache??
What is the difference between condition & filter?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain is data mart?
can anybody tell me about complicated object you have created
What would you consider as your biggest achievement and why?
Explain how many universes can be created in a project?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
what is universe null
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Is there any other repository domains rather than universe, security, document?
Did you face any problems while creating reports? Name? Solutions?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
