How do implement event polling table?
Answer / madhu
In OBIEE Server event polling tables store information about updates in the underlying databases. These tables are used for cache management. An application that loads data into a data mart could be configured to add rows to an event polling table each time a database table is updated. The Analytics server polls this table at set intervals and invalidates cache entries corresponding to the updated tables.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is complex join, and where it is used?
What are the key configuration files in obiee?
How will you go about adding additional column to the repository in the presentation layer?
What is Authentication? How many types of authentication do we have in OBIEE?
What is a bridge table ?
Can you use physical join in BMM layer?
Why do we have multiple LTS in BMM layer? What is the purpose?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
Define pipeline. Did you use it in your projects?
How will you execute direct sql in obiee?
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?
How will you create interactive dashboards ?