Writen by
Devil
2:12 PM
-
67
Comments
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:
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 !!
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.
ReplyDeleteRegards,
Informatica training in chennai
Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important. Project Center in Chennai It’s what organizations do with the data that matters. Big data can be analyzed for insights that lead to better decisions and strategic business moves.
DeleteSpring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.
Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai
The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training
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.
ReplyDeleteOracle Course in Chennai | Oracle Training in Chennai | hadoop training in chennai
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.
ReplyDeleteJava Training in Chennai
.Net Training in Chennai
PHP Training in Chennai
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.
ReplyDeleteRegards,
SAP training in chennai|SAP course in chennai|SAP Course in Chennai|SAP Training|SAP courses in chennai
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.
ReplyDeletePHP Institutes in Chennai
best php training institute in chennai
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
ReplyDeleteIt’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
ReplyDeleteccna course in Chennai|ccna training in Chennai
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.
ReplyDeleteJAVA Training in Chennai | JAVA J2EE Training in Chennai | J2EE Training in Chennai
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.
ReplyDeleteUpdating 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.
ReplyDeleteDOT NET Training in Chennai | Dot net training | Best DOT NET Training institute in Chennai
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.
ReplyDeleteRegards,
sas training in Chennai|sas course in Chennai
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
ReplyDeleteGreat Article
ReplyDeleteJava Online Training | Java EE course
Java Training in Chennai | J2EE Training in Chennai | java j2ee training institutes in chennai ~ Java Course in Chennai | Java Training Institutes in Chennai
Java 360 | IT Technical Articles |Java Training Institutes
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.
ReplyDeleteRegards,
Python Training in Chennai|Angularjs training chennai|Fita Chennai reviews
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.
ReplyDeletehtml5 training in chennai | html5 training institutes in chennai | FITA Academy reviews
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.
ReplyDeleteweb designing course in chennai|web designing training in chennai|web designing courses in chennai
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()”?
ReplyDeleteRegards,
angularjs training in Chennai | angularjs training | angularjs training Chennai
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.
ReplyDeletehtml5 training in chennai | html5 training institutes in chennai | FITA Academy reviews
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.
ReplyDeleteRegards,
Angularjs training in chennai|Angularjs course in chennai
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.
ReplyDeleteOracle Training in Chennai | oracle dba training in chennai
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.
ReplyDeleteRegards,
.net training in chennai|DOT NET Training in Chennai|DOT NET Course in Chennai
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.
ReplyDeleteSelenium training in Chennai | Selenium course in Chennai | Selenium training institute in Chennai
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.
ReplyDeleteAndroid training in Chennai | Android course in Chennai | Android training institute in Chennai
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.
ReplyDeleteAngularjs Training in Chennai | angularjs course in chennai
To achieve a great career join web designing course.Web designing is more important to publish their ideas.
ReplyDeleteRegards
web designing course in chennai | wed designing training in chennai
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.
ReplyDeletePython Training in Chennai | Python Course in Chennai
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
ReplyDeleteWell Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
ReplyDeleteNode JS training in chennai | Node JS training institute in chennai
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
ReplyDeleteAngular 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
ReplyDeleteCommonJS Training in Chennai CommonJS Training Node.js Training in CHennai Node.js Training in chennai HTML5 Training in Chennai HTML5 Training in Chennai
ReplyDeleteJava Corporate Training Companies in Chennai Corporate Training Companies in India Corporate Training Companies in India
ReplyDeleteCorporate 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
The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.
ReplyDeleteDot net training in Chennai | dot net course in Chennai
Thanks for posting this useful content, Good to know about new things here, Let me share this,
ReplyDeleteAngularJS Training in Chennai | AngularJS Training | Best AngularJS Training Institute in Chennai
Great post!! Your screenshots speaks more :) Thanks for sharing.
ReplyDelete.Selenium training in Chennai | Best Selenium training institute in Chennai
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
ReplyDeleteGreat information. I have got some important suggestions from it.
ReplyDeleteFilm editing course in chennai
I have read your blog, it was good to read & I am getting some useful info's through your blog keep sharing.
ReplyDeleteCloud Computing training institute in Gurgaon | ethical hacking training in Gurgaon
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.
ReplyDeleteCyber Security Projects for Final Year
JavaScript Training in Chennai
Project Centers in Chennai
JavaScript Training in Chennai
The blog you shared is very good. I expect more information from you like this blog. Thankyou.
ReplyDeleteArtificial Intelligence Course in Chennai
ai courses in chennai
artificial intelligence training in chennai
ai classes in chennai
best artificial intelligence training in chennai
Hadoop Training in Bangalore
salesforce training in bangalore
Python Training in Bangalore
Great post. keep sharing such a worthy information
ReplyDeleteTally Course in chennai
Tally Course in Bangalore
Tally Training in Bangalore
Tally training coimbatore
Tally course in madurai
Tally Course in Hyderabad
Tally Training in Chennai
Tally Course in Coimbatore
Tally Training in Hyderabad
Tally institute in Bangalore
Selenium Course in Bangalore
Excellent post, From this post i got more detailed informations.
ReplyDeleteAWS Training in Bangalore
AWS Training in Chennai
AWS Course in Bangalore
Best AWS Training in Bangalore
AWS Training Institutes in Bangalore
AWS Certification Training in Bangalore
Data Science Courses in Bangalore
DevOps Training in Bangalore
PHP Training in Bangalore
DOT NET Training in Bangalore
Great Post!!! Thanks for the data update and waiting for your new updates.
ReplyDeleteAndroid Training in Chennai
Android Course in Chennai
android development course in chennai
Android training
Android Training in Annanagar
Android training in vadapalani
Digital Marketing Course in Chennai
Python Training in Chennai
Big data training in chennai
JAVA Training in Chennai
The blog you shared is very good. I expect more information from you like this blog. Thankyou.
ReplyDeletePython Training in bangalore
Python Course in Bangalore
Angularjs course Bangalore
Angularjs Training in Bangalore
Web Designing Course in bangalore
Web Development courses in bangalore
Salesforce Course in Bangalore
salesforce training in bangalore
Big Data Training in Bangalore
Hadoop Training in Bangalore
I love it whenever reviews people come together and share opinions. Great website, stick with it!
ReplyDelete"Good Posting. Extra-ordinary way to narrate the concepts. Thanks for sharing..
ReplyDeleteDigital Marketing Training Course in Chennai | Digital Marketing Training Course in Anna Nagar | Digital Marketing Training Course in OMR | Digital Marketing Training Course in Porur | Digital Marketing Training Course in Tambaram | Digital Marketing Training Course in Velachery
"
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
ReplyDeleteDot 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
IEEE Cloud computing DOamin is a general term for anything that involves delivering hosted services over the Internet. cloud computing projects The cloud projects for cse is a metaphor for a global network of remote servers which operates as a single ecosystem, commonly associated with the Internet. IEEE FInal Year Networking Projects for CSE Domains Networking Projects cloud computing is the delivery of computing projects services—including servers, storage, databases, networking projects, software, analytics, and intelligence
ReplyDeleteJavaScript Training in Chennai
JavaScript Training in Chennai
I am looking for and I love to post a comment that "The content of your post is awesome" Great work! document data entry
ReplyDeleteI 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.
ReplyDeleteS4 Hana Simple Logistics
S4 Hana Simple Logistics Training
This was an excellent info being posted. This would definitely help the needed ones to a greater extend.
ReplyDeleteastrologers in india
astrology online
best astrologer in andhra pradesh
best astrology online
astrology
famous astrologer in andhra pradesh
best astrologer near me
top 10 astrologers in andhra pradesh
This blog is so nice to me. I will keep on coming here again and again. Visit my link as well.. ecommerce data entry
ReplyDeleteThanks 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
ReplyDeleteThank you for sharing.
ReplyDeleteData Science Online Training
Python Online Training
Salesforce Online Training
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
ReplyDeleteMua vé tại Aivivu, tham khảo
ReplyDeletechuyến bay từ singapore về việt nam hôm nay
vé máy bay hải phòng đi sài gòn
đặt vé máy bay đi hà nội vietjet
tphcm nha trang
vé máy bay sài gòn đi quy nhơn
I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post. Wedding DJ
ReplyDeleteIn 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
ReplyDeleteThe 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
ReplyDeleteAwesome blog. Thanks for sharing such a worthy information....
ReplyDeletePython Training in Bangalore
Python Classes in Pune
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
ReplyDeleteIn 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
ReplyDeleteParty rentals Fontana
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
ReplyDeleteLearn More
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.
ReplyDeleteEZ Bounce
bounce house rentals
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
ReplyDeleteclick here
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
ReplyDelete2 Dads Bounce Houses Peoria