Interview Questions   Tutorials   Discussions   Programs   Videos   

OBIEE - What are Alias tables and what is the use of Alias table?

asked kiran123 February 8, 2012 09:28 PM  

What are Alias tables and what is the use of Alias table?


1 Answers

answered By SRVMTrainings   0  
Alias tables is also a physical table but with the type of Alias. It is basically a reference to the logical table source and it will inherit all the column definitions of the logical table source. An Alias can a be a reference to any of the logical source systems such as stored procedures, physical tables, sql statements etc..Alias tables are very important in designing a physical layer.We use Alias table when we need to use an existing table more than once.If you know sql inner joins, you will understand easily, how we use there same table like sales a, sales b.Also we use alias tables when we need to use different column names, keys, joins etc..To help star or snowflakes structures in the Business model layer.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!