What is the purpose of Alias Tables?
- 1 Answers
- 2693 Views
- I also Faced
- E-Mail Answers
Answer / madhu
An Alias table is a physical table with the type of Alias. It is a reference to a physical table, and inherits all its column definitions and some properties from the physical table. A logical table source shows how the logical objects are mapped to the physical layer and can be mapped to physical tables, stored procedures and select statements. An alias table can be a reference to any of these logical table source types.
Alias Tables can be an important part of designing a physical layer. The following is a list of the main reasons to create an alias table:
1. To reuse an existing table more than once in your physical layer (without having to import it several times)
2. To set up multiple alias tables, each with different keys, names, or joins
3. To help you design sophisticated star or snowflake structures in the business model layer. Alias tables are critical in the process of converting ER Schemas to Dimensional Schemas.
| Is This Answer Correct ? | 1 Yes | 0 No |
How analytics process your request when you create your requests?
How to sort columns in rpd and web?
What is a table alias in obiee 11g? Where and how will you create it?
Can you use physical join in BMM layer?
How do you know which report is hitting which table, either the fact table or the aggregate table?
Define pipeline. Did you use it in your projects?
How do you define the relationship between facts and dimensions in BMM layer?
If you want to create new logical column where will you create (in repository or dashboard) why?
How many bi services node can be clustered together?
How will you do different types of narrative reports in obiee?
How will you do sort in reports in obiee.
From where u get the logical query of your request?
Teradata 
