cancel
Showing results for 
Search instead for 
Did you mean: 

Compare data between 2 different systems before an update

darshthakkar
Valued Contributor

Hi Team,

My pipeline has a source system as Snowflake and target system as Salesforce
There are 2 fields that needs to be updated in Salesforce but these should be updated ONLY if the data has changed in snowflake.

I was going ahead with the field in snowflake table “Last_Updated_Date” for an update to actually happen however to optimize this and not hit Salesforce with multiple records considering they don’t have an actual update on those 2 fields, I want to compare the data and pass ONLY those records which has an update to those 2 fields. I tried with “Diff” snap but is there any better option than “Diff” snap?

Thanking you in advance for your time, inputs and suggestions.

Regards,
Darsh

1 ACCEPTED SOLUTION

darshthakkar
Valued Contributor

Native string functionalities like .localeCompare and .match does the trick.
Closing this thread for now.

View solution in original post

1 REPLY 1

darshthakkar
Valued Contributor

Native string functionalities like .localeCompare and .match does the trick.
Closing this thread for now.