Record dropped during NULL handling
Posted: Thu Jul 16, 2009 2:53 pm
The job looks like:
Seq File1->Transformer1->Standardize->Transformer2->Seq File2
While converting the data from Tranformer2 to Seq File2, the job is giving the following error:
APT_CombinedOperatorController(1),0: Field 'Exterior_MXADDR' from input dataset '0' is NULL. Record dropped. [transform/tfmop_functions.C:147]
Other details:
In Tranformer2, i have used a derivation for Exterior_MXADDR which is :
If DSLink74.Exterior_MXADDR = "7777777777" or DSLink74.Exterior_MXADDR = "" then "SN" else NullToEmpty(DSLink74.Exterior_MXADDR)
For SeqFile2, format properties are:
NULL Field value: NULL
Quote: None
Delimiter: | ( same are the porperties for SeqFile1 too)
Hence, as far as i see, i have taken due care to handle the nulls, still because of NULLs in the field Exterior_MXADDR, the records are getting dropped. What can be the solution.
Seq File1->Transformer1->Standardize->Transformer2->Seq File2
While converting the data from Tranformer2 to Seq File2, the job is giving the following error:
APT_CombinedOperatorController(1),0: Field 'Exterior_MXADDR' from input dataset '0' is NULL. Record dropped. [transform/tfmop_functions.C:147]
Other details:
In Tranformer2, i have used a derivation for Exterior_MXADDR which is :
If DSLink74.Exterior_MXADDR = "7777777777" or DSLink74.Exterior_MXADDR = "" then "SN" else NullToEmpty(DSLink74.Exterior_MXADDR)
For SeqFile2, format properties are:
NULL Field value: NULL
Quote: None
Delimiter: | ( same are the porperties for SeqFile1 too)
Hence, as far as i see, i have taken due care to handle the nulls, still because of NULLs in the field Exterior_MXADDR, the records are getting dropped. What can be the solution.