I wanted to confirm if there's any option like 'Delete data before loading' or 'Append/Truncate' when working with CSV file as target? We have similar options while working with template tables/tables.
I want to implement similar functionality in flat file target. Is there any way, we can do so?
Thanks in advance for all your help.