Latest News

Monday, September 15, 2014

OBIEE 11G Event Polling table

OBIEE 11G Event Polling table  / OBIEE 11G Event Pooling table

Oracle BI Server event polling table is used to notify the Oracle BI Server that one or more physical tables have been updated and the query cache entries on these  tables are stale/Old.


How Event Polling table Works:
1)Each row that is added to an event table represents a single update event, Example an update to a Product table.
2)Oracle BI Server cache system reads rows from the event table, It extracts the physical table information from the rows and purges stale/old cache entries that reference those physical tables.


Features of Event Polling table :
1) It is a physical table that resides on a database accessible to the Oracle BI Server.
2) It can resides in its own database, or in a database with other tables, but it requires a fixed schema.
3) It is exposed only in the Physical layer of the Administration Tool, Tick the Dialog box that identifies it as being an Oracle BI Server event table.
4) It does require the event table to be populated each time a database table is updated.



How to use an Event Polling table at ETL Level:
 A Common way of updating the event table is by including a SQL INSERT statements in the extraction and load scripts/programs that populate the databases. Where an INSERT statements add one row to the event table each time a physical table is modified.

Configuring Event Polling table in the Oracle BI repository:
1) Create the table:

In 10g: under below location EVT Script can be found/ or below script can be used*

Obi_Home\bi\server\Schema\SAEPT.Oracle.sql

--------------------------------------
--  Create the Event Polling Table. --
--------------------------------------
CREATE TABLE S_NQ_EPT (
  UPDATE_TYPE    DECIMAL(10,0)  DEFAULT 1       NOT NULL,
  UPDATE_TS      DATE           DEFAULT SYSDATE NOT NULL,
  DATABASE_NAME  VARCHAR2(120)                      NULL,
  CATALOG_NAME   VARCHAR2(120)                      NULL,
  SCHEMA_NAME    VARCHAR2(120)                      NULL,
  TABLE_NAME     VARCHAR2(120)                  NOT NULL,
  OTHER_RESERVED VARCHAR2(120)  DEFAULT NULL        NULL 
) ;

PS: In 11g, the table is already present in the BIPLATFORM metadata repository.

2) Now import the Table into the RPD Physical Layer (Using import Metadata)
3)Go to the Utilities
4)Select Oracle BI Event Tables, then click on execute
5)Select the Table from the List, Give polling Frequency as 15 minutes/ or as required and Click on ok.



6) EPT table turns Yellow on completion of the process.

Have a Great Caching !! 


  • Google+
  • Pinterest
« PREV
NEXT »

41 comments

  1. I have read your blog, it was good to read & I am getting some useful info's through your blog keep sharing... Informatica is an ETL tools helps to transform your old business leads into new vision. Learn informatica training in Chennai from corporate professionals with very good experience in informatica tool.
    Regards,
    Informatica training in chennai

    ReplyDelete
  2. There are lots of information about oracle have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get to the next level in oracle. Thanks for sharing this.

    Oracle Course in Chennai | Oracle Training in Chennai | hadoop training in chennai

    ReplyDelete
  3. Thanks for sharing this niche useful informative post to our knowledge, Actually SAP is ERP software that can be used in many companies for their day to day business activities it has great scope in future.
    Regards,
    SAP training in chennai|SAP course in chennai|SAP Course in Chennai|SAP Training|SAP courses in chennai

    ReplyDelete
  4. Updating to latest technology is one's responsibility. Article like this are truly inspiring and worth able to read. You have done a great job by posting it in here. Thanks for sharing.

    PHP Institutes in Chennai
    best php training institute in chennai

    ReplyDelete
  5. Thanks for your informative article on software testing. Your post helped me to understand the future and career prospects in software testing. Keep on updating your blog with such awesome article. Best software testing training institute in Chennai | Software Testing Training in Chennai | Software testing training institute Chennai

    ReplyDelete
  6. It’s too informative blog and I am getting conglomerations of info’s. Thanks for sharing; I would like to see your updates regularly so keep blogging. If anyone looking ccna just get here
    ccna course in Chennai|ccna training in Chennai

    ReplyDelete
  7. Automation will make any work to be completed so soon(Selenium training in chennai), in addition to this recording the actions is possible with automated tool. Your content explicitely states the same(Selenium training institutes in chennai). Thanks for sharing this worth able content in here. This was very useful to me as well. Keep blogging like this.

    ReplyDelete
  8. Thanks for sharing this pretty post to our knowledge, SAS is a program that assists to retrieve, managing and uploading the data & simply it’s an integration system of software for performing these actions, thanks for taking your time to discuss about this topic.
    Regards,
    sas training in Chennai|sas course in Chennai

    ReplyDelete
  9. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
    Regards,
    Python Training in Chennai|Angularjs training chennai|Fita Chennai reviews

    ReplyDelete
  10. As i am beginner, your post helped me to improve my skill set in angularjs. if you update update your post with advanced angularjs concepts, it will be quite useful for us.
    Regards,
    Angularjs training in chennai|Angularjs course in chennai

    ReplyDelete
  11. The oracle database is capable of storing the data in two forms such as logically in the form of table spaces and physically like data files.
    Oracle Training in Chennai | oracle dba training in chennai

    ReplyDelete
  12. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
    Regards,
    .net training in chennai|DOT NET Training in Chennai|DOT NET Course in Chennai

    ReplyDelete
  13. In India thenumber of smartphone users have been on a rise. Among them also the people using android is way to high. Being an android developer would be the dorrect career choice.
    Android training in Chennai | Android course in Chennai | Android training institute in Chennai

    ReplyDelete
  14. Angularjs is the great javascript framework that has some compelling features not for developers but also for the designers. Angularjs is very essential for the web developers to know about its importance.
    Angularjs Training in Chennai | angularjs course in chennai

    ReplyDelete
  15. To achieve a great career join web designing course.Web designing is more important to publish their ideas.
    Regards
    web designing course in chennai | wed designing training in chennai


    ReplyDelete
  16. Python is an object oriented high level programming language which is built in data structures combined with dynamic typing and dynamic binding making it very attractive for rapid application development.
    Python Training in Chennai | Python Course in Chennai

    ReplyDelete
  17. Thanks Admin for sharing such a useful post, I hope it’s useful to many individuals for whose looking this precious information to developing their skill.Selenium Training Chennai|software testing selenium training|Selenium Training in Chennai

    ReplyDelete
  18. CommonJS Training in Chennai CommonJS Training Node.js Training in CHennai Node.js Training in chennai HTML5 Training in Chennai HTML5 Training in Chennai

    ReplyDelete
  19. Thanks for your informative post!!! After completing my graduation, i am confused whether to choose web design as my career. Your article helped me to make a right choice.Best Angularjs Training in Chennai|| AngularJS Training in Chennai

    ReplyDelete
  20. Great information. I have got some important suggestions from it.
    Film editing course in chennai

    ReplyDelete
  21. I have read your blog, it was good to read & I am getting some useful info's through your blog keep sharing.

    Cloud Computing training institute in Gurgaon | ethical hacking training in Gurgaon

    ReplyDelete
  22. I love it whenever reviews people come together and share opinions. Great website, stick with it!

    ReplyDelete
  23. Thanks a lot for sharing such a good source with all, i appreciate your efforts taken for the same. I found this worth sharing and must share this with all


    Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery





    ReplyDelete
  24. I am looking for and I love to post a comment that "The content of your post is awesome" Great work! document data entry

    ReplyDelete
  25. I was very pleased to find this site. I wanted to thank you for this great read!! I definitely enjoying every little bit of it and I have you bookmarked to check out new stuff you post.

    S4 Hana Simple Logistics

    S4 Hana Simple Logistics Training

    ReplyDelete
  26. This blog is so nice to me. I will keep on coming here again and again. Visit my link as well.. ecommerce data entry

    ReplyDelete
  27. Thanks for sharing this information. I really like your blog post very much. You have really shared a informative and interesting blog post with people.. here’s a great article to Best Table Saw

    ReplyDelete
  28. The size of your decorative spreads and napkins will obviously rely upon the size of your table. Dressing your tables with lovely table cloths is the most sensational approach to change the climate of your occasion space and offer an individual expression with class, style, and shading. royal chairs for wedding

    ReplyDelete
  29. In the event that you are somewhat new to this area, enjoy some quality exploration before you settle on a specific installment passage. web-based reserved seating software

    ReplyDelete
  30. The spot was a microcosm of Parisian culture and ethos. Generally significant, it was viable with birthday man, Mike's scholarly bowed of psyche and tastes. TLearn about personal investments

    ReplyDelete
  31. There was no change to or relief from this daily practice. The sheer dullness of it caused me to feel like a machine, as though I would go on with this drudgery even after Jacques' passing. Deep Etiching Service

    ReplyDelete
  32. In the event that you observe any of the best total party gear rentals, it can give you a convenient agenda to assist with planning every one of the interesting subtleties that will make your occasion breathtaking.this website
    Party rentals Fontana

    ReplyDelete
  33. A smidgen of exploration can help you a great deal. Recall since jumpers cost pretty much than their rival, it means they are worse.Click Here
    Learn More

    ReplyDelete
  34. A jumper has its cutoff points very much like some other drive around. Try not to allow it to move past loaded with an excessive number of children.
    EZ Bounce
    bounce house rentals

    ReplyDelete
  35. Likewise assess how much space is accessible on the area, as Bounce Houses can be quite large. All things considered, jumping castle rentals are an extraordinary method for adding enjoyable to any event.ejfunday.com
    click here

    ReplyDelete
  36. On the off chance that conceivable, take a brief trip and see the jumping castle jumper before hand, just to be certain it is protected. Bounce house rentals Peoria AZ
    2 Dads Bounce Houses Peoria

    ReplyDelete