Delta Strategy for Clobs

[wyconian]

Hi everyone

I'm trying to come up with a 'fast' delta strategy for loading data from a clob field.  Any ideas?

I've tried a minus query transforming the clobs to chars but that takes ages, there is no 'update' date from the source application.

Any suggestions welcomed.

Thanks for your help.

Simon

[starschema]

One thing you could try, is storing the hash (md5, sha1, etc) of the CLOB field in your target table, you could then pull the business key and hash from the source table, and use this to compare against the hash in the target table, to determine if the field has changed or not.

Using the results of this comparison, you could then pull the full row for only rows where the CLOB has changed.

Depending on your requirements, it may make sense to hash the entire row, rather than just the CLOB column.

[wyconian]

Thanks for the advice, I'll check it out  :)