Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of Alias Tables?
- 1 Answers
- 3326 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 will change port of obiee answers?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
How online/offline mode impact development and delpoyment?
If you want to limit the users by the certain region to access only certain data, what would you do?
What are the major challenges you faced while creating the rpd?
What is the end to end life cycle of OBIEE?
What is write-back in obiee ?
can you change the location of the obiee repository?
How will you port changes for dashboards,reports,rpd from development to production?
How we are going to decide which schema we are going to implement in the data warehouse?
Have you created hierarchy in obiee. If so where and how?
Did you create any new logical column in BMM layer, how?
Teradata 
