SetNULL function

[dodda]

Hi all,

Iam requirement regarding SetNULL function.

Actually , my source file is .txt file with 5 columns.

And my target consists of 10 columns is also .txt file. And there is a transformer is there in between source and target.

All the source columns should map to target .

And the remaining 5 columns should be hardcoded and the data for these columns should be null. So i used SetNULL() function. The job is executed fine.But the data is not written into target file.

can you please help me out, what iam missing?

Your help is greatly appreciated.

[bkumar103]

Check the director log , check the records exported in the log.
The log will certainly help you to figure out the problem.

[ag_ram]

dodda,

Please check these posts:

viewtopic.php?t=117629

viewtopic.php?t=117831&highlight=

Solution is to be - assign any character(string of chars also) to mean(to be represented) as NULL in Sequential file using the option "Null Field value" in the Sequential File Stage.

[ShaneMuir]

If you are writing to a txt file then you may as well set the 5 'NULL' columns to blank instead, then you won't have to worry about null handling at all. You can do this by putting '' (two single quotes or two double quotes) in the field derivation of the transform.