| |
GeekInterview.com > Interview Questions > Data Warehousing > BO Designer
| Print | |
Question: In what situation we have to use alias& and in what situation we to use contexts?
|
| April 04, 2007 06:54:23 |
#5 |
| srikar |
Member Since: Visitor Total Comments: N/A |
RE: In what situation we have to use alias& and in wh...
|
hi , this is srikar.my suggestion is
1. we can go for alias when ever there is multiple usage of that particular table.....else go for contexts..
2.we use contexts ... when ever there is a many to one relationship between 2 fact tables and 1 look up table(nothing but charm trap)
3.if there is a necessary to use more than 1 alias to solve the loop..then go for contexts....
|
| |
Back To Question | |
