Skip to main content
This revision made May 21, 2012 19:03, 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.
Difference compared to previous revision
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.
|}- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/Experimental_KMs_MySQL.zip 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.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKM_File_to_Oracle_(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.
|}
 
 
Close
loading
Please Confirm
Close