Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to join two tables and delete from one of them the rows that join.
I need to join tDBOutput_4 with ODS_SF_L_SRV_SR and delete from this last one all the rows that respect the join condition.
For the ODS_SF_L_SRV_SR that is the result of the join, I set the action on data as "delete".
Is this logic correct? Otherwise, how this should be done?
Also, when I try to run the job, the following error appears:
and I can't understand what this "after_tDBInput1" is.
Please check all fields in Input Component are mapped or not ? Error message is indicating same .
Hi Team,
I need to implement insert, update and delete logic at the same time in my Main table -A based on multiple keys from different table - B( which is daily coming data)
Logic to implement -
if in table- B new records come or same records as in table A - then I need to insert/update table B. (This I have implemented)
now I need to delete those records from table A which are not present in B but present in A.
Example -
lets A has 100 records and B has 50 out of which 45 records are same as in A
So in A it should contains only those existing records which has (same key + new records) which came from B.
It should delete those records from A which are not present in B
I have tried using look up model and added capture rejected data as false. But still its not deleting those records.