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 many bi services node can be clustered together?
Have you created hierarchy in obiee. If so where and how?
What are the different types of variables in obiee 11g? Explain
What is time series wizard? When and how do you use it?
What are the challenges you faced while making of reports?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
How to get sql from obiee for reports?
What are the major challenges you faced while creating the rpd?
What is star schema and snowflake schema?
What is authentication? How many types of authentication.
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How to enable drills in a given column data?
Can you run multiple rpd’s in a single obiee instance?
How will change port of obiee answers?
What are the different types of security you have worked in obiee?
