Bill Inmon has recently posted an article on "Why has Data Mining struggled so much?" The article discusses 7 diferent reasons why data mining has struggled, as it has been around for a very long time. The main points are 1. We have been waiting a long time for it to become available in a usable way 2. Data mining ...
We all know that we should purge the ODI log on a regular basis. if we log everything or if we run near real time batches. You can either purge the log manually from the Operator module or you can use the ODIPurgeLog tool. As per Metalink 424663.1 the following tables contain information concerning Session runtime executions
SNP_EXP_TXT (starting with ODI 10.1.3 versions):
SNP_SESS_TASK_LOG.I_TXT_TASK_MESS = SNP_EXP_TXT.I_TXT
SNP_STEP_LOG.I_TXT_STEP_MESS = SNP_EXP_TXT.I_TXT
SNP_VAR_SESS.I_TXT_VAR = SNP_EXP_TXT.I_TXT
SNP_VAR_SESS.I_TXT_DEF_T = SNP_EXP_TXT.I_TXT
SNP_SESSION.I_TXT_SESS_MESS = SNP_EXP_TXT.I_TXT
SNP_SESSION.I_TXT_SESS_PARAMS = SNP_EXP_TXT.I_TXT
When you ...
I promise that this will be the last post on analytic functions this month; but I came across this proposal to extend analytic functions with a comparative window function on Tom Kyte's blog yesterday (also make sure to review the actual paper). Basically this new type of analytic function would allow you to compare the current row in a window ...
Thank you all for your entries to the recent quiz. The guys from Packt should be shortly sending out the e-books to the winners. Today I will walk you through some of the possible solutions and also briefly touch upon performance of these. Last week's contest was based on a classic SQL problem. Anthony Molinaro, the author of the SQL ...
We'll do something completely different today and have a quiz. And you can even win something. Thanks to the guys at Packt Publishing I have two e-books to giveaway. Oracle Essbase 9 Implementation Guide and Business Process Execution Language for Web Services When you visit their website make sure to have a look at their free section. They are always ...