Alias

A logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins.
  • Interview Candidate
  • 6
  • 3447

  
Showing Answers 1 - 6 of 6 Answers

jagadeswar reddy.Palagani

  • Aug 3rd, 2005
 

the purpose of alias is to resolve strectural issues in the design of universe

  Was this answer useful?  Yes

sithusithu

  • Jan 27th, 2006
 

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

  Was this answer useful?  Yes

Suresh

  • Jun 25th, 2006
 

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.

  Was this answer useful?  Yes

ASHOK1324

  • Apr 19th, 2009
 

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.


  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