Skip to main content
This revision made May 31, 2012 22:34, 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.
Difference compared to previous revision
| [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 C== Knowledge Modules Samples To download, right-click on Sample link and select Save Link As... ... | 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 to Oracle SQLUnload-EXTTABLE] | This KM is a simple/limited KM which is for use when transferring data from a singleontrol A table
in an MS SQL Server database direct to the same table (name, columns) in Oracle.
|- | [htt
p://java.net/rojects/oracledi/downloappend ds/download/ODI/Knowledge%20Modules/IKM_Teradata_to_Teradata__BTEQ__v1.zip BIGIKM DATA Teradata to Teradata BTEQ ] | 1.)] | - AIntegration Knowledge Moule
- Integration from Tera
data to Teradata using BTEQ.
- Ability to use INSERT, UPSERT, UPDATE or DELETE BTEQ Scripts (specified with the
OPERATION_MODE option)dded an Option "
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/LKM_DB2_MVS__to_Oracle__JCL_
Unload_-_USESQLLDR__v1.zip 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 F_CREATE_TATP command.
- Loads data from a D
B2 to Oracle using SQLLDR
|- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/LKM_
EBCDIC_File_to_Oracle__SQLLDBLE_FOR_APPR__v1.zip LKM ENBCD"IC File to Futo Oracle SQLLDR] | This LKM oads flat file data into Oracle by using the SQL*LOADER utility.
Call to SQL*LOADER is mad
e and stdout and stdrr are redirectedlly Seed v into log files. eryr/> A specific log file is created by SQL*LOADER. r/> |- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/KM_LKM_File_to_Oracle__SQLLDR__with_EBCDIC_Option.xml LKM File to Oracle SQLLDR with EBCDIC Option] | This LKM loads flat file data into Oracle by using the SQL*LOADER utility.
Th
e original LKM File to SQLLDR from ODI 11.1.1.3 wa large tables (s extended tov include EBCDIC Data. r/> |- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%er 20020Modules/LKM_File_to_Oracle__SQLLDR_-Cyrillic_v1.zip GB),LKMFile to Oracle SQLLDR Cyr rigillic] | This LKM loads flaht upt file data into Oracle by using the SQL*LOADER utility.
|- | [http://java.net/proje
cts/oracledi/downloads/download/ODI/Knowledge%20Modules/LKM_SQL_to_Oracle__CLOB__v1.zip LKM SQL ton the creationo Oracle CLOB] | Loads data from any ISO-92 database to any ISO-92 compliant target database.
Specially modified for dealing with CLOB values.
|- | [http://java.net/projects/oracledi/downloads/download/OD
I/Knowledge%20Modules/klm_lkm_SQLtoOracle_Bulk_ExtTable.zip LKM SQL to Oracle Bulk ExtTable] | Bulk loads d of a table.
In Exadata,ata into it i Oracle - from any database <br/> |- | [http://java.net/projects/oracledi/downloads/download/ODI/Knowledge%20Modules/LKM_SQL_to_Oracle_Lob_v2.zip LKM SQL s better to uto Oracle Lob] | Loads data from any ISO-92 database to anyse a C ISO-92 compliant target database.
Specially modifireate Seleced for dealing with CLOB and BLOB values.
|- | [http://java.net/project
s/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.
|}
 
 
Close
loading
Please Confirm
Close