Skip to main content
This revision made May 31, 2012 22:18, 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
IKM File to File (Perl - Hadoop) High performance file to file processing Knowledge Module for Oracle Data Integrator that generates Perl code
with the optional capability of leveraging Hadoop parallel processing framework.
IKM for Oracle Table Function Illustration of how to generate SQL components such as Oracle Table Functions from within ODI.
IKM Oracle Incremental Update Lob Integrates data into an Oracle target table in incremental update mode.
Inexistent rows are inserted; already existing rows are updated. Data can be controlled.
IKM Oracle Incremental (No Minus) Integrates data in Oracle database target table in incremental update mode.
- Non-existent rows are inserted; existing rows are updated.
- Data can be controlled.
Inexistent rows are inserted; already existing rows are updated. Data can be controlled.
IKM PostgreSQL to File - Loads a file from a Postgres source
- The file is populated in truncate / insert mode.
- A flow table is created
IKM SQL as a Source Lets users build temporary interfaces that represent inline views or SQL as a source.
IKM SQL Control Append BIG DATA 1.) Added an Option "USE_CREATE_TABLE_FOR_APPEND" to Fully Seed very large tables (over 200 GB), right upon the creation of a table.
In Exadata, it is better to use a Create Select as statement.
IKM SQL Control Append BIG DATA 1.) Added an Option "USE_CREATE_TABLE_FOR_APPEND" to Fully Seed very large tables (over 200 GB), right upon the creation of a table.
In Exadata, it is better to use a Create Select as statement.
Difference compared to previous revision
- Non-existent rows are inserted; existing rows are updated.
- Data can be controlled.
Inexistent rows are inserted; already existing rows are updated. Data can be controlled.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKM_PostGre_to_File_v1.zip IKM PostgreSQL to File] | - Loads a file from a Postgres source
- The file is populated in truncate / insert mode.
- A flow table is created
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKMSQLasaSource.zip IKM SQL as a Source ] | Lets users build temporary interfaces that represent inline views or SQL as a source.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/KM_IKM_SQL_Control_Append_BIG_DATA.xml IKM SQL Control Append BIG DATA ] | 1.) Added an Option "USE_CREATE_TABLE_FOR_APPEND" to Fully Seed very large tables (over 200 GB), right upon the creation of a table.
In Exadata, it is better to use a Create Select as statement.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/IKM_SQL_to_Oracle__SQLUnload-EXTTABLE__v1.zip IKM SQL Control Append BIG DATA ] | 1.) Added an Option "USE_CREATE_TABLE_FOR_APPEND" to Fully Seed very large tables (over 200 GB), right upon the creation of a table.
In Exadata, it is better to use a Create Select as statement.
|
}
 
 
Close
loading
Please Confirm
Close