Can you please help how to handle below situation in teradata...
There are some records from the source whoch has NULL in the data itself ....for example
John is from teraNULLdata corpNULLoration
when i am trying to load these through mload its failing.I am able to find these NULL when i open the file in notepad ++
If the file is in unix, I could have done sed:
example: sed -e 's/NULL//g'? Can you try this before really impementing, if it is good for you.
Thanks raja ....I did try doing sed on the file and it worked but just want to know is there any way that we can handle in teradat code.