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.
Handling Null for a Concatenation column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse