@IF logic needs to implement - GG

Hi All,

I am working on a PoC and I need one suggestion from you.

Source A --- Ext A --- Pump A --- Rep A

                                                                                One Target_Table_T ( row_id, hash_source_a, hash_source_b, result)

Source B --- Ext B --- Pump B --- Rep B

Basically two different replicat process writing or merging in the same table based on the same row_id. The target table is having those columns.

Now, when my Rep-B is pushing the value in Target_table_T, it should check whether the hash_source_a is there or not, if not there then it will simply push the hash_source_b value in the table, But if the other hash value from different source is already present in that target table, it will check whether it is same or not, if it same, put some value in result column, if NOT same, put some value in result column.