I have a requirement like based on condition i need to delete the rows from 23 teradata tables, any ideas please. (from single job).
It will be run once in a year.
You can write stored procedure to delete the 22 tables.
pass the filename, path as parameter, read the file and store the value of the content in variables and then while calling the stored procedure pass on the variables value as parameters to the procedures.
in the second job you can have a MLOAD/TPUMP stage,
and based on the condition, delete from the tables.
you can have 23 delete statement in the MLOAD/TPUMP script, and each statement will run only when the condition statisfy.
You could use a Teradata API stage that contains the following queries:
DELETE FROM Table1 WHERE condition;
DELETE FROM Table2 WHERE condition;
etc.
You could put the queries in the main SQL or in the Before/After tab depending on whether you want to send in a row for the condition or want to send 0 rows and base the condition on job parameters.