You are not logged in.
I have migrated all the data from Oracle(Source Table) to Postgres( Target Table) and then i have deleted 1 row from Oracle(Source Table) and then I did 2 things
1) I have applied "INSERT OR UPDATE" action on table . But still it is giving me the deleted row in Postgres(Target Table).
2) I have applied the "DELETE" action on table . While doing this i am getting the deleted row rather than the rows which are left in Oracle.
How to get the left rows rather than deleted row?
**I dont have to apply "DROP AND CREATE"action on Target Table.
Kindly help me out.
First, Are you sure you have deleted 1 rows in source table? If you select the 'delete' action, it will delete the rows from target table, which have the same key in source table.
Second, you can use a tOracleRow to execute a sql statement to delete rows.