How to compare the coloumns with Primarykey (Varchar Data Type) in target?

[Former Member]

Hello All,

We are using BODS 4.2 and working on Webservice Integration, I need to update the records target table (HANA)if there is any change from source, here in Target table we are using Primary key (Varchar), Through table comparison i tried to compare the columns but i am unable to compare between source and target with Primary key which is Varchar type, can any one help on this issue.

Thanks in Advance.

[former_member187605]

There' s no obvious reason why table_comparison wouldn't work with varchar PK columns.

Refer to https://wiki.scn.sap.com/wiki/display/EIM/Table_comparison+transform%3A+Comparison+method+settings+a... for an overview of features.