Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-08-2025 09:56 AM
Thank you for the suggestion @Hubert-Dudek. I explored both those options however my data does not have a consistent key column that would allow me to use AUTO CDCs.
Instead, I'm grabbing the entire batch that was last loaded and then doing a replace downstream using
INSERT INTO TABLE gold
REPLACE USING loadkey
SELECT * FROM silver
Unfortunately, this last step is not supported in LDP so i have to run it as a separate step in the job. But it is very simple and works well.
