We have some files which are being loaded to teradata tables. The files are loaded via different pipelines in informatica and parallel insert, update and delete operations are taking place on the target table.
How can we avoid that at the database level?
Do we have any workaround for that?
Use locking modifiers before DML statements to avoid deadlock issue.