We have a condition where I need to transfer the data from Oracle to Intermediate SQL and from Intermediate SQL to client SQL. I can not connect Oracle to Client SQL.
Whenever any new records will appear in Oracle i need to transfer to intermediate SQL and from there i need to transfer the new records to client SQL.
Please suggest how can we check if any records exist, I can not implement batch movement