0

I have a clob column and I need to perform CDC on it to flag it for update/insert/nochange based on the change in the CLOB data. My source/Target are teradata. ETL tool we are using is informatica. I need to perform CDC on this CLOB column. My table will have one Key column and this CLOB column, i.e., 2 columns.

Could any one help me how can I achieve this scenario either in Teradata or informatica or using both.

Thanks in advance.

S.P
  • 1,775
  • 5
  • 14
  • 21

1 Answers1

1

My guess would be to go for MD5. Load data and store MD5 hash. Upon reload, calculate MD5 and compare with stored one. Direct CLOB comparison might be troublesome and time and memory consuming.

I've found few more comments and answers here, take a look.

Maciejg
  • 3,088
  • 1
  • 17
  • 30