Skip to main content
This revision made September 19, 2012 01:15, 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 to Oracle SQLUnload-EXTTABLE This KM is a simple/limited KM which is for use when transferring data from a single table
in an MS SQL Server database direct to the same table (name, columns) in Oracle.
IKM Teradata to Teradata BTEQ - Integration Knowledge Module
- Integration from Teradata to Teradata using BTEQ.
- Ability to use INSERT, UPSERT, UPDATE or DELETE BTEQ Scripts (specified with the OPERATION_MODE option)
LKM DB2 MVS to Oracle JCL Unload - SQLLDR Create and Execute a JCL to download a table in a sequentilal file in MVS system
- transfer a sequential file to a Agent machine using a FTP command.
- Loads data from a DB2 to Oracle using SQLLDR
LKM EBCDIC File to Oracle SQLLDR This LKM loads flat file data into Oracle by using the SQL*LOADER utility.
Call to SQL*LOADER is made and stdout and stderr are redirected into log files.
A specific log file is created by SQL*LOADER.
LKM File to Oracle SQLLDR with EBCDIC Option This LKM loads flat file data into Oracle by using the SQL*LOADER utility.
The original LKM File to SQLLDR from ODI 11.1.1.3 was extended to include EBCDIC Data.
LKM File to Oracle SQLLDR Cyrillic This LKM loads flat file data into Oracle by using the SQL*LOADER utility.
LKM SQL to Oracle CLOB Loads data from any ISO-92 database to any ISO-92 compliant target database.
Specially modified for dealing with CLOB values.
LKM SQL to Oracle Bulk ExtTable Bulk loads data into Oracle - from any database
LKM SQL to Oracle Lob Loads data from any ISO-92 database to any ISO-92 compliant target database.
Specially modified for dealing with CLOB and BLOB values.
LKM VSAM to Oracle JCL IDCAMS - SQLLDR Loads data from an MVS source into Oracle.
IKM Oracle 11g UnPivot Control Append Description :
- Pivot data from one row to many rows
- Uses Oracle's New UnPivot Command in Oracle 11g Database .
IKM Oracle 11g Pivot Control Append Description :
- Pivot data from one row to many rows
- Uses Oracle's New Pivot Command in Oracle 11g Database .
}
Difference compared to previous revision
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/LKM_VSAM_to_Oracle__JCL_IDCAMS_-_SQLLDR__v1.zip LKM VSAM to Oracle JCL IDCAMS - SQLLDR] | Loads data from an MVS source into Oracle.
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/KM_IKM_Oracle_11g_UnPivot_Control_Append.xml IKM Oracle 11g UnPivot Control Append ] | Description :
- Pivot data from one row to many rows
- Uses Oracle's New UnPivot Command in Oracle 11g Database .
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/KM_IKM_Oracle_11g_Pivot_Control_Append.xml IKM Oracle 11g Pivot Control Append ] | Description :
- Pivot data from one row to many rows
- Uses Oracle's New Pivot Command in Oracle 11g Database .
|
}
 
 
Close
loading
Please Confirm
Close