BO Designer - In what situation we have to use alias& and in what situation we to use contexts?

GeekInterview.com > Interview Questions > Data Warehousing > BO Designer

Go To First | Previous Question | Next Question

BO Designer | Question 89 of 117

In what situation we have to use alias& and in what situation we to use contexts?

Total Answers and Comments: 5

Last Update: April 30, 2007 Asked by: SAMARTH

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 20, 2006 11:57:25

Sravan

RE: In what situation we have to use alias& and in wh...

Alias are used to eliminate the Loops.

Is this answer useful? Yes | No

January 05, 2007 16:41:53

Sri

RE: In what situation we have to use alias& and in wh...

Both are used to solve Join path problems.

Especially Contexts are used to solve Chasm traps and Aliases are used to solve Fan traps.

Thanks

Sri.

Is this answer useful? Yes | No

January 25, 2007 15:44:53

Latha03

Member Since: January 2007 Contribution: 20

RE: In what situation we have to use alias& and in wh...

HiAlias can be used when there is less complexity in loops and few fact tables where as Context can be used to resolve loops when more fact tables are present in the universe design.

Is this answer useful? Yes | No

January 29, 2007 23:57:33

silunayak

Member Since: January 2007 Contribution: 4

RE: In what situation we have to use alias& and in wh...

when we create alias or context we end up with Objects. If the objects you created is sounds like same then you can go for context. if the objects sounds different then you can go for alias. The main thing is that the best way to resolve the loop is alias.

Is this answer useful? Yes | No

April 30, 2007 06:54:23

srikar

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....

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank