I have a automation which pull the file(CSV) from SFTP location and paste it on to the data source and load the data using transform map. We get a new file for every 4 hours and transform map triggers for every 4 hours and processes the data, i have seen a behavior which i was not able to identify/troubleshoot.
Issue:
There was a record which is sent to the staging table which is got ignored with the comment "no filed values changed", later in the next update the record got updated, there is no difference in the source data, again in the 3rd time when the transform map ran again it showed the same comment as "no filed values changed"
Can some one help me to understand how it ignored first and why it updated?
@Ankur Bawiskar @Pradeep Sharma could you please help me understand the above
