![poedit update from sources finds nothing poedit update from sources finds nothing](https://hackix.com/wp-content/uploads/2010/01/poedit_new_catalog_keywords.png)
For example, reading from a CSV table where the underlying files can change between the multiple scans. Non-determinism in the source can arise in many ways. This is because merge may perform two scans of the source dataset and if the data produced by the two scans are different, the final changes made to the table can be incorrect.
#Poedit update from sources finds nothing how to#
See the change data capture example-it shows how to preprocess the change dataset (that is, the source dataset) to retain only the latest change for each key before applying that change into the target Delta table. You can preprocess the source table to eliminate the possibility of multiple matches. According to the SQL semantics of merge, such an update operation is ambiguous as it is unclear which source row should be used to update the matched target row.