I have a source and target and I need to update insert and delete the target based on the source.
For this I made a mapping with Dynamic lookup and two update strategy one insert and the other for update.
This is working fine with inserts and updates, now I need to delete the records in target which are not in source.
Note*** I cannot do truncate or delete on all the records in the target it got some child tables I have to delete if the records is not in source.
This is going to be a Cascade Delete, so we can delete records which will delete all the records in child tables.
This is my current mapping which is working for insert and update..
Source ------> Source Qualifier ----->Dynamic Lookup ------>Router ------->update(insert) -------> Target
------->update(update) -------> Target
So now I need the delete logic how can I implement Ã¢Â€Â¦Ã¢Â€Â¦????????????