Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How the users created differs from rpd/answers/dashboards level?
What is level based metrics.how will you create it?
What are different types of joins that are possible in obiee rpd?
How will you go about adding additional column to the repository in the presentation layer?
What are global filter and how they differ from column filter?
What is time series wizard? When and how do you use it?
Can you run multiple rpd’s in a single obiee instance?
What is write-back in obiee ?
How will you enable or disable caching in the system level and table level?
What is a table alias in obiee 11g? Where and how will you create it?
What are the key configuration files in obiee?
How will you create report from two subject areas
How we are going to decide which schema we are going to implement in the data warehouse?
From where u get the logical query of your request?
How online/offline mode impact development and delpoyment?
