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.
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.
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.
Posts
