DSXchange

Hi,

i am getting the following error
APT_CombinedOperatorController,0: Field 'REGN_I' from input dataset '0' is NULL. Record dropped.

source is DB2 and field REGN_I data type is varchar, it contains Null values.

source is extracting the data correctly, but at the time of transformation , it is truncating all null values.
i have used the null handling function NullToEmpty on the filed REGN_I before loading the data to .csv file.
but still some records are truncating from the source.
source has 2000records
file has loaded with 1936 records and remaining records are dropped
what could be the reason?

Hi,
There is an env variable that disables combination of operators (look in the job's parameters tab and press the env variable to get the list.
If you'll set iy to true then the error message will point to the stage causing this warning.
After you'll identify the location of the problem you can take the apropriate action.

By theway did you search in this forum?, there are lots of posts with the info you need.

IHTH,

Thanks a lot roy
job is perfectly working without losing any source data...

Do you mind sharing the findings and solution you found,
So others might benefit from it?

Sure roy why not...
I have selected env variable $APT_DISABLE_COMBINATION operator and set to True(meaning that " it prevents operators from being combined into the process") in job parameters tab then i ran the job.
In log file , it's clearly given the warning message pointed at transformer stage where input field have some null values, so i rectified that error by using null handling function NullToEmpty on that field and Nullable as yes.
So, all source records are successfully transformed into a destination file.