I have a sql query where there is NULL in some of the columns. I'm trying to create a delimited text file as destination.
Instead of NULL in Text file while data is passing thru dervied transformation , I want NULL to be replaced as Nothing.
In the text file the columns are having a delimiter as Pipe. Data for NULL should be replaced by nothing and the text columns in the file should look empty inbetween pipe like || . As u can see inbetween there in no null . its nothing with no quotes.