Nesting ODI substitution method calls. Part 1.

Uli Bethke Oracle Data Integrator (ODI), Oracle Warehouse Builder

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes I am not getting around doing too much blogging on ODI these days. I have recently started a new project on OBIEE and ODI and it must be two years or so since I have last used OBIEE. I can tell ...

Exploring the Oracle Data Miner Interface

Uli Bethke Business Intelligence, data mining, Oracle, Training, Uncategorized

Once you have successfully installed Oracle Data Miner and established a connection you will be presented with the main ODM window with the navigator pane on the left hand side. All the tasks that you will need to do in ODM can be accessed from the Navigator pane or by the menu across the top of the window. The Navigator ...

ODI - getSession("SESS_PARAMS" )

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes In response to my article on the ODI variable debug procedure Craig Stewart has pointed out an undocumented parameter of the getSession method that does the same with one big limitation. The parameter SESS_PARAMS will print out any variables that have ...

ODI snippets: Query to retrieve source and target columns in an interface

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes The following query can be used to retrieve the source columns/tables and target columns/tables for interfaces in a specified project NOTE: BELOW QUERY IS VALID FOR ODI 10g ONLY!!! ODI 11g has introduced the concept of data sets, which invalidates below ...