ODI snippets: Purge Log and shrink space

Uli Bethke Oracle, Oracle Data Integrator (ODI)

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

When you ...

Comparative Window Functions: Proposed Extensions to Analytic Functions

Uli Bethke analytic functions, Oracle, SQL for Analysis

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 ...

SQL quiz revisited: ROW_NUMBER, LAST_VALUE, FIRST_VALUE and the SQL knights value problem.

Uli Bethke analytic functions, Oracle, SQL for Analysis

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 ...

Irish BI SIG: Mark Rittman to present on Essbase, OBIEE, Hyperion Planning

Uli Bethke Irish BI SIG

Don't miss Mark Rittman's presentations on Essbase and OBIEE integration and a technical introduction to Hyperion Planning. There is still time to register. As usual the event will take place at the Oracle offices in Dublin. Paul Weston from Ireland's leading Essbase consultancy BDMS will give an overview on new features in Essbase 11. Personally I have no experience with ...

How to prepare for Data Mining

Uli Bethke Best Practice, data mining, Training

There is a new article by Eric King of The Modeling Agency on How to Prepare for Data Mining. It has some interesting points on various aspects that you would need to look out for. I think some of the important things is that you need to plan such a project carefully, that you understand what you can get out ...