I have a Microsoft Access Database Table. I need to delete all the records in it and just keep the schema. Basically, the output will be an empty table. There are 10,000 records in the table.
Delete all records in Table A. Table A will be empty. Just keep the Table A schema.
I know I can use the SQLExecutor with a SQL Statement to do this, but how to do this using Transformer(s)?
What is the best way to go about this?