title: ODI how to compare clob fields
body: <p>I'm trying to implement ODI scd km and the table has a clob field. I'm getting error in the step where it compares the clob value from the target table with the i$ temporary table. </p>
  
  <p>ORA-00932: inconsistent datatypes: expected - got CLOB</p>
  
  <p>Any suggestions on how to get past this error </p>