Gurus, I need help in converting a low value to spaces. Basically one of the column may contain low value and want to know how to validate low value data for conversion
PowerCenter doesn't understand binary format data, so you would need to convert it in PWX, before it gets to PowerCenter.
You could do that by using a row-level exit. Please note that doing that will degrade performance, because PWX would have to call an external program for each row that it processes from the source.
You might also be able to find some way to do this with a function - I haven't tried it, so I'm not certain.