Update Step1_EDL_To_SynapseLinkDV_CreateUpdate_SetupScript_DW.sql

microsoft / Dynamics-365-FastTrack-Implementation-Assets

Dynamics 365 FastTrack Implementation guides

MIT License

312 stars 196 forks source link

Update Step1_EDL_To_SynapseLinkDV_CreateUpdate_SetupScript_DW.sql #345

Open steinhorsttobias opened 2 months ago

steinhorsttobias commented 2 months ago

The proposal for deletion of code rows is because they prevent correct handling of deleted data. Because the deleted rows are deleted in the _tmp-table (current code rows 237-239) the corresponding data in the target table won't be deleted anymore (see code rows 289-292). Due to this deleted rows will stay in the target tables forever and through deletion of deleted rows in the _tmp-table there aren't any traces that a deletion has happened.

LeeKnight344 commented 1 month ago

@steinhorsttobias Has this been merged? I'm guessing I'll be needing this. Currently using the Incremental CSV export option for Synapse Link for Dataverse and we're seeing deleted records still show in the target DB.

steinhorsttobias commented 1 month ago

No, there wasn't any reaction to my pull request proposal from the ones who are responsible for the repository yet. I don't have permission to do this.