Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
suppose in incremental load insert and update the records...how to identify the only insert and updated records...what is the condition
Usually the new and updated records can be identified by a modification date (or maybe a record version number) field. If that's not available then you may be able to identify the new records by checking if the record identifier already exists. If it doesn't then it's a new record. Changed records can be identified by computing a hash of all the fields of the record and compare it to the hashes of all other records. But you really want to have a modification date (or record version number field as second choice). Insist on one if it doesn't exist yet.
Hi Gybert Wassennaar,
if suppose i want to only view updated records...how it is possible