GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  BO Designer
Next Question 
 BO Designer  |  Question 1 of 117    Print  
Alias
A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.


  
Total Answers and Comments: 4 Last Update: April 20, 2009   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 03, 2005 01:10:40   #1  
jagadeswar reddy.Palagani        

RE: Alias
the purpose of alias is to resolve strectural issues in the design of universe
 
Is this answer useful? Yes | No
January 27, 2006 03:51:22   #2  
sithusithu Member Since: December 2005   Contribution: 161    

RE: Alias

An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases more than one alias may be necessary for a given table.

Cheers

Sithu


 
Is this answer useful? Yes | No
June 25, 2006 11:36:54   #3  
Suresh        

RE: Alias

Actually What happens in the back end (i.e) in database end while alias is performed whether it points to one table or too many table. How the performance will be in universe level.

Please help me by explaining with this concept correctly because i faced such question by interviewer.


 
Is this answer useful? Yes | No
April 19, 2009 15:23:57   #4  
ASHOK1324 Member Since: April 2009   Contribution: 36    

RE: Alias

An alias is identical to base table with different name. The data in alias is
exactly same as original table/but the different name tricks SQL into accepting
that we are using 2 different tables.


An alias breaks the loop by using the same table twice in the same query for
a different purpose.


Creation of alias tables is not much recommended in BO designer. Instead it
is recommended to delete the unnecessary joins that have n-n cardinality to
resolve loops.



 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape