I have added a new column[DECIMAL(10,2) , NOT NULL] to a table.
Now i have to load the table using the unload file. The unload file doesn't have the data for the newly added column. Since the newly added column happens to be a not null. The data is not getting loaded into the TABLE.
Iam using FASTLOAD to load the table.
Is there a way to add a constant value like 7 to the newly added column while loading the table for all the records.