IICS | Upsert (Update else Insert) example |

1. In case of duplicate records UPDATE operation given priority.
2. But the key thing the target table must have PRIMARY KEY defined to make use of this operation.
3. Hence, all records would be handled as UPDATE otherwise INSERT would be considered as fresh record.
4. Be mindful to use this logic whenever you deal with small volume of data to foresee good performance.

[@dileepkumarreddyg8840]

Please make a video on SQL transformation in IICS

[@keeplearning9447]

You can watch my store procedure transformation earlier explained about SQL transformation already hope that helps

[@dadanoor1088]

Hi sir, please make a video on how to understand the log file, which we downloaded in DI

[@keeplearning9447]

Okay

[@mohanpavan6615]

Sir..if we already defined UPSERT in Mapping Level why do we need to again select Treat Source Rows as UPDATE as without setting this property also it works as expected ..kindly confirm

[@jahirbasha7257]

Hi sir good evening, I hope you are doing good, the topics what you had explained was very clear and easily understandable

[@keeplearning9447]

Thank you

[@RevMaxMotoVlogs]

Hi, is it also possible to do UPSERT in a flat file?