I have 80 to 90 tables and each has one file to get loaded.(file1 for T1, file2 T2 etc respectively)
Can i create one single script(fload,bteq or mload) for loading all these tables.
My input parameters will be filename and the target table--> run script <file1> <targettable1>
Is that possible by any methods in teradata? I might have to take table structure from DBC.tables or columns!!!!
Thanks in advance!!!!!