Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of Alias Tables?
- 1 Answers
- 3203 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 |
If you want to limit the users by the certain region to access only certain data, what would you do?
How to enable drills in a given column data?
What is connection pool and how many connection pools did you have in your last project?
Can you migrate the presentation layer to a different server.
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
How do implement event polling table?
If you want to create new logical column where will you create (in repository or dashboard) why?
Can you run multiple rpd’s in a single obiee instance?
How do you work in a multi user environment? What are the steps?
How analytics process your request when you create your requests?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
How will you do sort in reports in obiee.
Teradata 
