how to get null values to the target....

kannan_ayyanar · Post by **kannan_ayyanar** » Sun Jun 06, 2010 4:18 am

i have designed a job like ODBC enterprises as source and target... in between source and target one transformer for mapping... problem is NULL values from source are getting rejected in the transformer.. i wants to get it into the target... in the target i have defined all the columns as null able but still values are getting dropped...

please help me in this issue.....

thanks....

chulett · Post by **chulett** » Sun Jun 06, 2010 5:46 am

Any particular messages being logged by the job? How exactly are you doing your null handling?

kannan_ayyanar · Post by **kannan_ayyanar** » Sun Jun 06, 2010 5:59 am

if the column value is NULL... its getting dropped... its going to reject link from the transformer.. i am not doing any null handling.... as of now i am using stage variable, constraint and sending to target.. but without that i wants to send to target....

kannan_ayyanar · Post by **kannan_ayyanar** » Sun Jun 06, 2010 6:11 am

my question is why the null values are getting dropped....? why its not going to target...??? any setting has to be done in transformer..?????

chulett · Post by **chulett** » Sun Jun 06, 2010 6:28 am

Please answer both of my questions. Are you using any constraints on your (non-reject) output links? Rows will 'reject' if they go down no other link or if there is a 'write failure'.