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

Showing Answers 1 - 2 of 2 Answers

Sravan

  • Dec 20th, 2006
 

Alias are used to eliminate the Loops.

Sri

  • Jan 5th, 2007
 

Hi,

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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.

srikar

  • Apr 30th, 2007
 

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

  Was this answer useful?  Yes

ppvidya.p

  • Oct 21st, 2010
 

Hi...

In the Loop if we have one fact table and two Look up tables,then we use Aliases.

In the Loop,if we have more than one Fact table then we go for Contexts...

At a time a look up tablecan talk to atmost one fact table.

  Was this answer useful?  Yes

Both are used to resolve loops.


Alias is used in case of dimension tables to resolve the loop

Where in context is used to resolve loop which occurs for fact tables..


Thanks, 
SN

  Was this answer useful?  Yes

yogi9x

  • May 30th, 2011
 

Alias: Alias is used when two dim tables and one fact table are there in the loop, alias is used for one dim table which has less outer joins.

 
Context: Context are used when there are 2 fact tables and one dim table in the loop, we create context for one join between one fact and dim in the loop.
 

  Was this answer useful?  Yes

vengi

  • May 23rd, 2012
 

More than 3 dimension tables and one fact table is there in that scenario on that situation we use alias technics.

  Was this answer useful?  Yes

Alias: When we have 2 dimension tables with 1 fact table in the schema at that time it is best way to resolve the loop using Alias.We can create alias on lookup table which has both ends 1-1 relationship.

Context: When we have 2 dimension tables with more than 1 fact table in the schema at that time it is best way to resolve the loop using Context by defining the separate path.

  Was this answer useful?  Yes

purvanshu

  • Jan 26th, 2014
 

Hi....
Hope it is useful.....
Alias use to solve Fan Traps problem in Fan Traps problem 3 tables will be participate, table A connected to table B with one-to-many relationship, table B connected to table C with one-to-many relationship. It means the relationship between table A,B,C is one-to-many-to-many. For Example- one customer having multiple account number, one bank account number connected with multiple loan number.

Contexts- Context use to solve Chasm Traps problem in Chasm Traps problem 3 table will be participate with many-to-one relationship. many-to-one relationship converge to a single table. For Example- Many customer in an organization there can be a many salary structure resolve by the Contexts.

  Was this answer useful?  Yes

T.Sreenu

  • Jul 2nd, 2014
 

Alias is to resolve the loop between three tables and one Fact table , context is used to resolve loop between three tables and more than one fact Table

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions