Microsoft Fabric Copy Job: Simplify Data Movement| DP 600 | DP 700- Upsert not covered- New Feature

[@natassakefala4472]

Thanks for the video, really good! I have one question though, if you update a row from Sales (change the SalesDate-incremental column) from sales_nospace table, the copy job with incremental load on this column, will update this row?or it will not take the change like in dbo.item?

[@AmitChandak]

Update can not reflected as part of copy job as of now

[@nobody50000]

With mirroring, i can get the tables from sql into Fabric. So, not sure what value add copy job is doing in this case sir?

[@AmitChandak]

Mirroring works on its own for CDC. In the copy job, we are providing additional information for it. Mirroring is available for four sources as of now, while the copy job can be used for more sources. There are many options in Fabric for same stuff, just need to use fit for purpose.