DSXchange

Hi,
I have a scenario like 2 input stages one lookup and target stage.
My source tables are like

Table A
col1
a
b
c

Table B
col1,col2
a, 100
b, 200

Table A (main link),Table B (reference link) connected to lookup stage.
Lookup condition is continuous.
Lookup stage output should be like

Col1,Col2
a ,100
b ,200
c ,null

But in lookup stage output link in metadata properties Col2 is not null.
As null passing to non nullable column,
third row c ,null should be dropped.
Actually lookup stage generating blank value and passing row as c ,[blank].
Please suggest me how to handle blank spaces in lookup stage.


Thanks,