Hi guys, I am trying to transfer data from oracle (source) to postgres (destination) in incremental append mode but it does not show option for same

add cursor field

As per my understanding, cursor should be timestamp field, but my source data does not contain any timestamp field.. Can u help me with same?

if it doesnt have any cursor field how will it make a incremental load?

so what should I do in such scenario as i dont have timestamp field in source in oracle to use airbyte

full refesh is the only option with airbyte

I have data which comparatively large data in amount.. I know full refresh is little time consuming but apart from that what can be other problem that I have to deal with.. can u help me to know same

I think you will need to do some custom ETL which will check what is max ID on your data and then do the refresh on that. Check Talend Open studio. I dont think airbyte will suffice your need