Is there any way I can delete the records from the target table? I have below cases in mind. Would be really helpful if someone can reply on it.
1. To truncate load the target table. i.e to delete all records from target table and load it with new records. In case if I use Sinkmode.REPLACE, it will delete the target table structure and creates new table as per the datatype mentioned (not recommended as it can create different datatype some time).
2. To mark records from source table for deletion and to delete the same records from target table based on keys.
Thanks,
Kishor