Update Each Record generated in data Model to table in database.
Hi ,
When data Model generates a set of records , for each row generated , should join with table in database and update some columns in table
For Example :
Input Param1 ( values 'yes' or 'N')
param2 date
Id code reason
1 A REASON1
2 C REASON2
3 F REASON3
4 D REASON4
the above data is generated in data model , for each row of ID , should join with tableA using ID column and update each row of tableA.
please advice what is the best way to achieve.
Thanks