mhamedbenjmaa opened a new issue, #6876:
URL: https://github.com/apache/hop/issues/6876

   ### What would you like to happen?
   
   Is there a way to ake a difference by adding a check box to track deleted 
record like the feature in dbt for snapshot   
   
   `hard_deletes: invalidate`
   
   this way the target table will just put an ends date to the deleted row from 
the source when not found 
   
   usually with classic ETL you need to get the source keys, compare manually 
with destinations keys, flag missing one etc.....
    
   since you are already preforming lookup, only missing couple of line code to 
add to get the feature, would be to flag missing rows from source and flag them 
with an end date 
   
   Imagine how hard an SSIS developer or a DataStage would cary to have a 
checkbox like that :D 
   
   thanks
   
   ### Issue Priority
   
   Priority: 2
   
   ### Issue Component
   
   Component: Transforms


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to