Interview Questions   Tutorials   Discussions   Programs   Videos   

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




372
views
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.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


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!

Alert