video1.0<iframe src="https://www.loom.com/embed/4d63de8f8b744971a0e18f3dd246ec90" frameborder="0" width="2218" height="1663" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>16632218Loomhttps://www.loom.com16632218https://cdn.loom.com/sessions/thumbnails/4d63de8f8b744971a0e18f3dd246ec90-d166d1ab0e318202.gif127.7097In this video, I demonstrate a special scenario in AETL where we run SQL statements before and after writing to a SQL database. I explain how to update our employee master data daily by truncating the existing data without any comparisons. Additionally, I show how to update employee codes in JSON format using a function. Please take a look at the execution log to see that everything was successful. I would appreciate your feedback on this process.