Thursday, January 30, 2014
ODI is big on CDC, but its loading the data with respect to BLOBs and CLOBs datatypes does not work as desired with out of the Box KMs.
These KMs can be found as a part of Oracle Community Knowledge Module
You can find the modified KM here
Contribution Author: Kiran Bokam
Oracle addressed these issues by providing custom LKMs for these complex data types. These KMs handle BLOBs and CLOBs well but, the performance is not acceptable. If you are using low data volume then this is not an issue. If not look into DBlinks or SQl loader for loading high data volume containing BLOBs and
CLOBs
CLOBs
These KMs can be found as a part of Oracle Community Knowledge Module
- LKM SQL to Oracle Lob : Description of the KM here
- LKM SQL to Oracle (CLOB): Description of the KM here
CLOBs and BLOBs and consistent CDC:
Above KM does not correctly support consistent CDC, so we modified few steps in the KMs for it to play well with consistent CDC.You can find the modified KM here
Modified Step 1: Lock Journalized tables
New Command Text Original Command Text
Modified Step 2: Cleanup Journalized tables
New Command Text Original Command Text
Contribution Author: Kiran Bokam
The URL's are not working
ReplyDeletehttps://dl.dropboxusercontent.com/u/3566634/LKM_SQL_to_Oracle_(CLOB)_v1.xml