On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?




We can use do this by identifying the granularity of the target table .
We can use CRC external procedure after that to compare newly generated CRC no. with the old one and if they do not match then update the row.

No comments:

Post a Comment