How to write data from different metanodes

Hi Team,

I have done all the transformations using the DB nodes and last node is DB Query node. I wanna remove the DB reader node and wanna write data

I pull data from a table in XYZ. schema and then I write the data to a table in ABC. schema.

Before writing the data to ABC schema I would like to verify the table is empty or not if it is empty then write the data or else delete the data in table. I am using DB Delete node

I wanna remove the DB reader node and wanna write data from DB Query node to a table in ABC schema.

Please let me know for further information.

Thanks,

Subramanyam Kinthada