What is the purpose of Alias Tables?
- 1 Answers
- 2378 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 do you implement security using External Tables and LDAP?
How do i disable cache for only 2 particular tables?
What is query repository tool?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
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?
Have you created hierarchy in obiee. If so where and how?
Can you use outer join in BMM layer?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What you will do when your report is not fetching right data?
what is guided navigation?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
If you want to limit the users by the certain region to access only certain data, what would you do?
Teradata 
