Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of Alias Tables?
- 1 Answers
- 3392 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 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?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
Do you know about Initialization Blocks? Can you give me an example where you used them?
Did you create any new logical column in BMM layer, how?
How will you create interactive dashboards ?
What is clusterservices in obiee ? Why its used?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
What are the things you can do in the BMM layer?
You worked on standalone or integrated system?
Teradata 
