Interested to Buy Any Domain ? << Click Here >> for more details...
What is the purpose of Alias Tables?
- 1 Answers
- 3309 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 |
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How will you port changes for dashboards,reports,rpd from development to production?
What you will do when your report is not fetching right data?
What is connection pool and how many connection pools did you have in your last project?
If you want to create new logical column where will you create (in repository or dashboard) why?
What are the different log files in obiee?
How to enable drills in a given column data?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What is authentication? How many types of authentication.
Can you run multiple rpd’s in a single obiee instance?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
You worked on standalone or integrated system?
Teradata 
