Data Warehousing - pls tell me in which situation context and alias r going to use?

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 3 of 92

pls tell me in which situation context and alias r going to use?

Total Answers and Comments: 6

Last Update: April 29, 2007 Asked by: M.chandra sekhar

Sponsored Links

Best Rated Answer

—

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

November 13, 2005 01:28:37

mayuri

RE: pls tell me in which situation context and alias r...

when they are role playing dimensions we go for aliases n when we dont have dont have role playing dimensions we go for context

Is this answer useful? Yes | No

November 22, 2005 09:13:14

shujatalimajid

Member Since: November 2005 Contribution: 1

RE: pls tell me in which situation context and alias r...

As far as my knowledge is concerned alias are used for duplication of names.But where as contexts are used to resolve the loops concept, because using loops we can't determine which way to follow.If we have loops it produces undetermined results.

Is this answer useful? Yes | No

December 03, 2005 05:12:12

kirandev

RE: pls tell me in which situation context and alias r...

wn we go for alias and when we go for context

Is this answer useful? Yes | No

January 04, 2006 04:53:14

sithusithu

Member Since: December 2005 Contribution: 161

RE: pls tell me in which situation context and alias r...

Aliases

Which are logical pointers to an alternate table name. This command is dimmed until you select a table within the Structure window.You can define aliases to resolve the loops that Designer detected in the universe structure.This feature works only if you have defined at least one join and all the cardinalities in the joins have been detected.

Context

Can be used to resolve loops in the universe, You can create contexts manually, or cause them to be detected by Designer. When contexts are useful, Designer suggests a list of contexts that you can create.

Sithu

Is this answer useful? Yes | No

March 28, 2007 14:50:25

mrudula

RE: pls tell me in which situation context and alias r...

context is nothing but specifying the name of the path

the place where u cannot resolve the loops with allias there comes concept of context

alias is nothing but the duplicate name of some other table

Is this answer useful? Yes | No

April 29, 2007 02:33:20

Manju

RE: pls tell me in which situation context and alias r...

Context is basically used when we will have conformed dimension in the loop........

Is this answer useful? Yes | No

Go To Top