Hi Team,
My requirement is simple, if any updates/inserts/updates happened to one our Azure SQL Server database table, the CDC has to generate the .csv file for the incremental in the Azure storage.
It is working as expected, but the CDC creates a folder and file on the same Target Name.
Here is my CDC Source and Target.
when the Insert happened in the database, the CDC generates the incremental file, but it also generates a file outside the folder as below.
Inside the incr-mist-data/incoming/incr folder as below.
It should create the .csv file under the incr-mist-data/incoming/incr folder, but it creates a 0KB file in the folder incr-mist-data/incoming ?? Please let me know how to avoid it.
Thanks
Rajan