Skip to main content
This revision made May 21, 2012 19:09, by julien.testut

Knowledge Modules Samples


To download, right-click on Sample link and select Save Link As...

Sample Description
IKM Oracle Incremental Update (MERGE) For Exadata Added a detection strategy which was not included in the original KM.
The Detection Strategies are NONE, MINUS, POST_FLOW, NOT EXISTS and a new one MERGE. The default MINUS was not performant on Exadata.
Use NOT EXISTS instead. If no Staging is required, use MERGE. When MERGE is used, Flow Control must be set to false.
Upon a Detection Strategy of Merge, no I$ tables will be created. Instead the Merge Statement will contain the entire source select.
This is very efficient on Exadata when the Source and Target are on the same database.
Experimental_KMs_MySQL.zip Knowledge Modules: MySQL (Experimental)
A collection of knowledge modules for use with ODI.
Unsupported, but should provide a starting point for developing more robust solutions for these use cases.
IKM File to Oracle (ExtTable) Append This KM is a simple/limited KM which is for use when transferring data from a file direct to a table in Oracle.
It uses Oracle's EXTERNAL TABLE functionality to get the data into the target table.
IKM File to Oracle (SQLLDR) DIRECT APPEND Multiple Loads data from a file to an Oracle Database using the SQL*LOADER utility.
Call to SQL*LOADER is made through a Jython call to an Operating System command.
IKM Oracle (Generic Pivot) Integration Knowledge Module
- Pivot data from one row to many rows
IKM Oracle (Pivot) Integration Knowledge Module
- Pivot data from one row to many rows
Difference compared to previous revision
A collection of knowledge modules for use with ODI.
Unsupported, but should provide a starting point for developing more robust solutions for these use cases.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKM_File_to_Oracle_(_ExtTable)ExtTable__Append_v1.zip IKM File to Oracle (ExtTable) Append] | This KM is a simple/limited KM which is for use when transferring data from a file direct to a table in Oracle.
It uses Oracle's EXTERNAL TABLE functionality to get the data into the target table.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKM_File_to_Oracle__SQLLDR__DIRECT_APPEND_Multiple_v1.zip IKM File to Oracle (SQLLDR) DIRECT APPEND Multiple] | Loads data from a file to an Oracle Database using the SQL*LOADER utility.
Call to SQL*LOADER is made through a Jython call to an Operating System command.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKM_Oracle__Generic_Pivot__v1.zip IKM Oracle (Generic Pivot)] | Integration Knowledge Module
- Pivot data from one row to many rows
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKM_Oracle__Pivot__v1.zip IKM Oracle (Pivot)] | Integration Knowledge Module
- Pivot data from one row to many rows

|}
 
 
Close
loading
Please Confirm
Close