Handling Null for a Concatenation column
Posted: Wed Mar 18, 2009 10:35 am
I have two source columns like AGT_PHN_INTL_PFX length 3 nullable yes,
and second one AGT_PHN_PHN_NBRlength 25 nullable No. I am trying to concate these two columns in the transformer derivation like AGT_PHN_INTL_PFX : AGT_PHN_PHN_NBR. In the target sequential file these two column values should be conctinated. I am running the job source records are not loading.
I am getting warnnings:
Seq_SE_Demo: When checking operator: When validating export schema: At field "CART_ACCPTR_TELEPHONE_NUM": Exporting nullable field without null handling properties
xfm_SE_Demo,0: Field 'AGT_PHN_INTL_PFX' from input dataset '0' is NULL. Record dropped.
and second one AGT_PHN_PHN_NBRlength 25 nullable No. I am trying to concate these two columns in the transformer derivation like AGT_PHN_INTL_PFX : AGT_PHN_PHN_NBR. In the target sequential file these two column values should be conctinated. I am running the job source records are not loading.
I am getting warnnings:
Seq_SE_Demo: When checking operator: When validating export schema: At field "CART_ACCPTR_TELEPHONE_NUM": Exporting nullable field without null handling properties
xfm_SE_Demo,0: Field 'AGT_PHN_INTL_PFX' from input dataset '0' is NULL. Record dropped.