Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘Alias Table’ Category

Physical Layer – Alias Physical Table

Posted by Santosh Kumar Gidadmani on February 17, 2011

An alias physical table type specifies that the physical table object is an alias to another table.
Uses of Alias Table in physical layer:
1. Single dimension table simultaneously appears several times in the same fact table.
2. To configure the self join in Physical Layer
3. Re structure and organize the physical tables
4. To separate two date columns used in the same table and requires join for some calculation.
5. It’s easier to give the access of objects to users in case of Multi User Development Environment.

Alias Synchronization
An alias table always inherits all of the column definitions from the source table and synchronization happens automatically. Consequently, columns in an alias table cannot be modified. All columns opened from an alias table become read-only. If you add or delete any columns in the source table, the same changes will automatically happen in alias table.

How to create an Alias table:
Right click on any table and select New Object and click on Alias, provide the name of the table and click Ok. The alias table appears with a green arrow alias icon in the Physical layer.

– Santosh

Posted in Alias Table, OBIEE 10g, OBIEE 10g RPD, Physical Layer Objects | Leave a Comment »

%d bloggers like this: