I have an input dataset, on which I want to perform an operation to highlight which records are obsolete, and then permanently delete those records from the input dataset.
I was trying to use SQL transformations, but I cannot make the output dataset the same as the input dataset. Could someone help?