Skip to Content

Failed to update and delete data with Table_Comparison

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.

ds_1.PNG (6.8 kB)
ds_2.PNG (31.0 kB)
ds_3.PNG (12.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2016 at 05:03 AM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 21, 2016 at 09:46 AM

    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?

    ds_4.PNG (12.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.