cascading-jdbc : How to delete records from target table?

18 views
Skip to first unread message

Kishor Baindoor

unread,
May 18, 2016, 7:49:45 AM5/18/16
to cascading-user
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

Andre Kelpe

unread,
May 23, 2016, 5:35:28 AM5/23/16
to cascading-user
See my reply in the other thread please.

- André
> --
> You received this message because you are subscribed to the Google Groups
> "cascading-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to cascading-use...@googlegroups.com.
> To post to this group, send email to cascadi...@googlegroups.com.
> Visit this group at https://groups.google.com/group/cascading-user.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/cascading-user/042cc63e-ba71-46b4-8c6d-b7092022b293%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.



--
André Kelpe
an...@concurrentinc.com
http://concurrentinc.com
Reply all
Reply to author
Forward
0 new messages