Incremental | Append mode is not working correctly for source connector OracleDB

Connector Questions & Issues
1

Connection: OracleDB > Redshift

Settings

image
image1340×802 67.6 KB

Source Data

image
image1114×325 23.4 KB

Ran multiple syncs without making any changes in the source data, therefore incremental mode should not append any new row in destination.
But it appends the same data again and again.

image
image1654×303 45.6 KB

2

But your cursor field is not the correct type: https://docs.airbyte.com/understanding-airbyte/connections/incremental-append#source-defined-cursor