I have a plan which reads a table from the source and checks the validity of around four columns(null checks and lookup verification). Once done with the validity checks I want to update one of the source table’s validation field with the value VALID or INVALID according to the result of the checks.
I see that the SQL Execute will help me to update the table for each record being processed in the plan. This is enough for my scenario. Thanks for the help.
When i tried to do with the JDBC writer it tried to insert the record. I haven’t tried the advanced option i will try with that also and see.
But just to clarify the JDBC writer component is this how the component will work?
- Before script executes
- Record being processed by the plan will be inserted
- After script executes
If so in my scenario I don’t want the second step to happen. Is there a way to stop the JDBC writer from doing the second step.