Posted by : Arjun Lagisetty 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.

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

These KMs can be found as a part of Oracle Community Knowledge Module

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

Leave a Reply

Subscribe to Posts | Subscribe to Comments

Popular Post

Labels

Blog Archive

Copyright © ODI Pundits - Oracle Data Integrator - Maintained by Arjun Lagisetty