Delete data
<?xml version="1.0" encoding="UTF-8"?> <scenario> <name>Delete data</name> <description>Deletes data.</description> <script>delete_data</script> <driver>auto</driver> <sources> <source> <name>employee</name> <extract> <sql>select * from employee</sql> </extract> </source> </sources> <destinations> <destination> <name>employee</name> <!-- other possible actions are insert, merge, update --> <!-- insert is default and not require key attribute --> <load action="delete" key="EMPNO" /> </destination> </destinations> </scenario>