79237526

Date: 2024-11-29 15:09:18
Score: 2
Natty:
Report link

I learned that "Change Data Capture" available under Factory Resources works ok, but after an initial load. So there are 2 strategies when there is already some data in the Source:

  1. Use a "Copy Activity" to perform the initial load in the destination and then use the "Change Data Capture" OR
  2. Use a regular data flow in a pipeline with the "Full on first run, then incremental" run mode
Reasons:
  • No code block (0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Xile