You can maintain anotehr backup database to hold the tables which were unused for 2 to 3 months and delete from the main database.so that you can able to achive the space in the frequently used database.
Hi I am loading a file from Fastload script.
The file was create using fastexport from a Teradata table of 50 column.
Only 8 columns are used in the file creation , rest are '' to go as null. File is Pipe delimited
When i run fast load the table loaded has size two times as of the 1s teradta table( used for creating the file).
What could be the reason for this big size.