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 »

55 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 valuable information to our vision. You have posted a trust worthy blog keep sharing.
    Regards,
    Best Informatica Training In Chennai|Informatica training center in Chennai

    ReplyDelete
  4. I agree with your thoughts!!! As the demand of java programming application keeps on increasing, there is massive demand for java professionals in software development industries. Thus, taking training will assist students to be skilled java developers in leading MNCs.
    Java Training in Chennai
    .Net Training in Chennai
    PHP Training in Chennai

    ReplyDelete
  5. For management and troubleshooting of enormous databases, corporations square measure searching for qualified and licensed dispersions Hadoop experts for the duty. Hadoop Training in Chennai | Hadoop Training Chennai

    ReplyDelete
  6. 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
  7. 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
  8. 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
  9. 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
  10. Upgrading ourselves to the upcoming technology is the best way to survive in this modern and fast paced technology world. Reading contents like this will create a positive impact within me. Thanks for writing such a valuable content. Keep up this work.

    JAVA Training in Chennai | JAVA J2EE Training in Chennai | J2EE Training in Chennai

    ReplyDelete
  11. 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
  12. Updating with the latest technology and implementing it is the only way to survive in our niche. Thanks for making me understand through this article. You have done a great job by sharing this content in here. Keep writing article like this.

    DOT NET Training in Chennai | Dot net training | Best DOT NET Training institute in Chennai

    ReplyDelete
  13. 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
  14. Thanks for your information. QTP provide most precise and independent review about a software application. This automation testing tool is ideal to determine the performance and validity of a software application. QTP Course in Chennai | QTP training

    ReplyDelete
  15. 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
  16. Testing is very important before launching a web application or a mobile application because it can detect the error at an early stage, and it reduces the work of the developer.
    manual testing training institute in chennai | mobile application training in chennai | FITA Academy Chennai

    ReplyDelete
  17. The best thing about HTML5 is that it allows the developers to embed the video files, audio files, and high quality graphics without any third party applications.
    html5 training in chennai | html5 training institutes in chennai | FITA Academy reviews

    ReplyDelete
  18. The main thing which i like about web designing is that it needs creativity and we need to work differently acccording to our clients need this needs a creativity and innovation.
    web designing course in chennai|web designing training in chennai|web designing courses in chennai

    ReplyDelete
  19. Hi, actually I'am new to angularJs and infact I'am learning angularjs with online training. I'am having doubt, if you could solve the doubt for me that would be very helpful. The doubt is, how can I reset a “$timeout”, and disable a “$watch()”?
    Regards,
    angularjs training in Chennai | angularjs training | angularjs training Chennai

    ReplyDelete
  20. The best thing about HTML5 is that it allows the developers to embed the video files, audio files, and high quality graphics without any third party applications.
    html5 training in chennai | html5 training institutes in chennai | FITA Academy reviews

    ReplyDelete
  21. 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
  22. 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

  23. Very informative content that guided me to know the details about the training offered in different technology. Angular JS is a structural framework for dynamic web application and angular's data binding eliminates much of the code that you would otherwise write it.
    Angularjs Training in Chennai | angularjs course in chennai

    ReplyDelete
  24. 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
  25. Selenium is the best tool for software testing automation and it is used globally by the top companies across globe. Get training to use selenium and star yur career as a siftware tester today.
    Selenium training in Chennai | Selenium course in Chennai | Selenium training institute in Chennai

    ReplyDelete
  26. 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
  27. 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
  28. 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
  29. 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
  30. 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
  31. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    digital marketing course in Chennai | digital marketing training in Chennai

    ReplyDelete
  32. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Node JS training in chennai | Node JS training institute in chennai

    ReplyDelete
  33. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    web designing course in Chennai | web designing training in Chennai

    ReplyDelete
  34. we are offering best Obiee online training with work support and job assistance and high quality training facilities and well expert faculty
    for other details and register your demo contact
    obiee training in hyderabad

    ReplyDelete
  35. Thanks for Sharing the valuable information and thanks for sharing the wonderful article..We are glad to see such a wonderful article..
    QTP Training in Chennai | QTP Training Institute in Chennai | QTP Training

    ReplyDelete
  36. JMS Training Institutes in Chennai JMS Training Institutes in Chennai | JSP Training Institutes in Chennai | Spring Training Institutes in Chennai Spring Training Institutes in ChennaiMicroServices Training Institutes In Chennai Java MicroServices Training Institutes In Chennai
    Java EE Training Institutes in Chennai Java EE Training Institutes in Chennai

    ReplyDelete
  37. Online JSF Training JSF Training Institutes in Chennai Java Training Institutes Java Training Institutes Struts2 Training Institutes in Chennai Struts2 Training Institutes in Chennai EJB Training Institutes in Chennai EJB Training Institutes in Chennai

    ReplyDelete
  38. Hibernate Training Institutes in ChennaiHibernate Training Institutes in Chennai Hibernate Online Training Hibernate Online Training Hibernate Training in Chennai Hibernate Training in Chennai Java Online Training Java Online Training

    ReplyDelete
  39. Angular 2 Training in Chennai Angular 2 Training in Chennai JavaScript Training in Chennai JavaScript Training in Chennai ReactJS Training in CHennai ReactJS Training JQuery Training in Chennai JQuery Training in Chennai

    ReplyDelete
  40. 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
  41. Java Corporate Training Companies in Chennai Corporate Training Companies in India Corporate Training Companies in India

    Corporate Training in Chennai Corporate Training in Chennai

    Corporate Training Companies in India Corporate Training Companies in India

    Java Corporate Training Companies in India Java Corporate Training Companies in India

    ReplyDelete
  42. Excellent post!!!. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    cloud computing training in chennai | cloud computing courses in chennai

    ReplyDelete
  43. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
    Dot net training in Chennai | dot net course in Chennai

    ReplyDelete
  44. Thanks for posting this useful content, Good to know about new things here, Let me share this,
    AngularJS Training in Chennai | AngularJS Training | Best AngularJS Training Institute in Chennai

    ReplyDelete
  45. 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
  46. Great information. I have got some important suggestions from it.
    Film editing course in chennai

    ReplyDelete
  47. 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
  48. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for Final Year

    JavaScript Training in Chennai

    Project Centers in Chennai

    JavaScript Training in Chennai

    ReplyDelete