Skip to Content
0
Oct 08, 2020 at 07:06 PM

Delta load procedure - having variance from source to target hana

71 Views

Hi,

There's a stored procedure written to load delta records for multiple tables , it uses cursors, multiple tables are stored in a control table. The records from source are upserted in target hana after max delta timestamp column (max value taken from target).

However, for one table, the records are matching from source to target, but, when we compare tables with group by on a particular column, we see variance.

Example: account no:1 has status code: 10 in target, date: sep 23, but in source its value : 14, date: Oct 6. So, something is missing. In source, the value was updated but not in target.

This table has multiple delta load timestamp columns.

Thanks.