Failed to update and delete data with Table_Comparison

[jessie_wu01]

Hi all,

I am doing the incrementally replicate the data from postgres to hana database using table_comparison, the flow is as following

I can replicate the new added one, but failed to update the field data or delete the records in target table. The source table and target table is as following

The table_comparison configuration is as following. I use the id as Input primary key column and put all the left columns as compare columns, but failed to update fields and delete records.

Please help me out of this issue. Thanks.

[former_member316405 · Accepted solution]

Can you try using Map Operation transform after Table comparison and set as below?;

Input   Output

Normal   Normal

Insert     Insert

Update   Update

Delete    Delete

Let me know if this didn't help you?

[jessie_wu01 · Accepted solution]

Thanks. I added the Map Operation, but didn't work. Still can't update and delete the records in target table.

I changed the column type from long to varchar of the datastore table, does it matter? The original column type is long in datastore table after importing the schema, but table_comparison doesn't support the long type.

[former_member198401 · Accepted solution]

Yeah Jessie. The Long data type is not supported by Table Comparison transform. You will need to alter the datatype of the Long column to varchar.

Regards

Arun Sasi

[jessie_wu01 · Accepted solution]

create the target table with varchar type, not with text type and do the transfer in datastore.

[jessie_wu01]

from the log file, I can see 1 record to be merged as I update one field content of a record, but when I search the value in target database, I can't see the updated value,still the original value.

Anything step or configuration I missed?