Hi Team,
We have requirement where we have to populate target table using data from multiple source tables. And we do not have any column in source to identify if record is updated or newly created.
So we are simply checking if records exists (on key columns C1, C2) in target in update or else insert. here we are unnecessarily updating records which are actually not updated in source as we don't have any identifier.
Can we use STANDARD_HASH function to find if there is any update in existing records. If yes then can we use it in MERGE statement.
Or is there any other way to resolve this.
Thanks in advance.