Hi ,
I'm looking for inputs to identify and delete records from table 1.
I have 2 tables .Table 1 and Table 2. I have found a way to identify the inserts and updates from table 1 using the output tool (update ,insert if new option) and with left outer and union could accomplish this.
However , I'm trying to find a way to do deletion of records into table 2, ( I have to identify the records that are removed from Table 1 on daily basis and perform those deletes into table 2 ). I have a strategy to use select all from table 2 and left outer join with table 1 where the primary key is null , to identify the deletes, But not sure which transformation or tool i should use post this to get these deletes . Looked at output tool and there is no such option to pass filter in the sql.
Can some one pls suggest any work around here . Need to implement this by next week and out of options
I have added the current working workflow here in order to better understand my need and help update or add the delete flow into this under similar lines.
Appreciate any inputs !
