Interested to Buy Any Domain ? << Click Here >> for more details...
What is complex join, and where it is used?
- 1 Answers
- 2458 Views
- I also Faced
- E-Mail Answers
Answer / madhu
To join a dimension table and fact table in BMM layer we use a complex join.
| Is This Answer Correct ? | 1 Yes | 0 No |
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
How many bi services node can be clustered together?
can you change the location of the obiee repository?
Can you migrate the presentation layer to a different server.
Can you use outer join in BMM layer?
How to sort columns in rpd and web?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How do you know which report is hitting which table, either the fact table or the aggregate table?
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?
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 you will do when your report is not fetching right data?
What is star schema and snowflake schema?
Teradata 
