Concatenation with null values

[dr.murthy]

hi all,

i have an reqirement like concatenation of 4 fields into a single character,
but some of the fields having null records are dropped at the Transformer.
for example F1,F2,F3,F4
if any one of the field having null values these recorda are not loaded into next stage,transformer stage dropping these records.i handled these null values at oracle stage(source) by using NVL(F1,' ').
but its not giving proper results.

Any suggestions.

[dr.murthy]

can i concatenate null values with out hanling null property

[ray.wurlod]

No.

Think about it. I want to concatenate "abc" to an unknown value. What is the result?

"It's not working properly" is not a sufficient diagnosis.

[Pagadrai]

Hi,
Can you specify what are the actual and expected results?
You can try 'NullToEmpty' Function.