Field 'Emp_code' from input dataset '0' is NULL. Record drop
Moderators: chulett, rschirm, roy
Field 'Emp_code' from input dataset '0' is NULL. Record drop
Hi All,
I have use the dsxchange search, i found so many way to deal with this situation, but not able to resolve my issue.
I am getting the below warning messages in DS log.
Xfm_Validation,0: Field 'Emp_code' from input dataset '0' is NULL. Record dropped.
I am reading the field 'Emp_code' [Varchar2(1) NULL ] from oracle table using oracle enterprise stage. my traget is sequential file with same metadata 'Emp_code' [Varchar2(1) NULL]
I have handled the null while writing into sequentail stage. there i used Null field value = ''.
But still I am getting the same warning message.
Thanks
I have use the dsxchange search, i found so many way to deal with this situation, but not able to resolve my issue.
I am getting the below warning messages in DS log.
Xfm_Validation,0: Field 'Emp_code' from input dataset '0' is NULL. Record dropped.
I am reading the field 'Emp_code' [Varchar2(1) NULL ] from oracle table using oracle enterprise stage. my traget is sequential file with same metadata 'Emp_code' [Varchar2(1) NULL]
I have handled the null while writing into sequentail stage. there i used Null field value = ''.
But still I am getting the same warning message.
Thanks
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
-
- Participant
- Posts: 26
- Joined: Tue Oct 23, 2007 4:07 am
- Location: Blore,India
-
- Participant
- Posts: 26
- Joined: Tue Oct 23, 2007 4:07 am
- Location: Blore,India
It should work but r u recieving the same message? In the source query try to use NVL(EMP_CODE,'') as EMP_CODE.
Is that a direct mapping or do u have any intermediate stages between source and target.
In which stage u r recieving this 'Field 'Emp_code' from input dataset '0' is NULL. Record drop' mesage?
If this doesn't work try to NULLFIELDVALUE property in target sequential file as 0
Is that a direct mapping or do u have any intermediate stages between source and target.
In which stage u r recieving this 'Field 'Emp_code' from input dataset '0' is NULL. Record drop' mesage?
If this doesn't work try to NULLFIELDVALUE property in target sequential file as 0
asdfasdf
i am getting this message in transformer stage, i am not using any intermediate stages. or derivation.
i have one question. if a source filed is null and direct mapped to target field witout any trasformaiton, why we need to do any null handling.\
Thanks
i have one question. if a source filed is null and direct mapped to target field witout any trasformaiton, why we need to do any null handling.\
Thanks
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
-
- Participant
- Posts: 50
- Joined: Fri Dec 21, 2007 3:24 am
-
- Participant
- Posts: 26
- Joined: Tue Oct 23, 2007 4:07 am
- Location: Blore,India