Identify the two true statements about alias tables.
A.
Alias tables are set up to include best practice naming conventions for physical table
names.
B.
Alias tables are set up to create another physical copy of the data.
C.
Alias tables are set up to avoid triangular or circular joins.
D.
Alias tables are set up to create a copy of the data with a filter applied to it.
A and C
help? somebody can provide one sample that the alias table avoid circular join?
http://www.rittmanmead.com/2008/08/resolving-fan-traps-and-circular-joins-using-obiee/
one sample of that the alias table resolve the circular join