Field 'state_cd2' from input dataset '0' is NULL. Record dropped
I see this kind of warnings more in the director.
Actually we have values for the provided fields but why does it show NULL.
As it is null it drops.
any suggestions please
Records drop in Transformer.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
Records drop in Transformer.
Regards,
Kenny
Kenny
-
- Participant
- Posts: 43
- Joined: Thu May 29, 2008 8:41 pm
Re: Records drop in Transformer.
Use null handing. Thanks.
You obviously do have nulls in the data coming into the transformer. Perhaps you have an outer join, lookup or some other stage upstream of the transformer that may be introducing the nulls.
The record is dropped because the null exists in the column and you are using that column in a derivation which is doing more than just copying it to an output column. To avoid dropping the record, add null handling logic as is suggested by
chowdhurry99.
If you wish to view the dropped records, add a reject link that feeds to a Peek stage or some sort of file.
Regards,
The record is dropped because the null exists in the column and you are using that column in a derivation which is doing more than just copying it to an output column. To avoid dropping the record, add null handling logic as is suggested by
chowdhurry99.
If you wish to view the dropped records, add a reject link that feeds to a Peek stage or some sort of file.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 152
- Joined: Mon Mar 07, 2011 6:16 am
I guess you defined the field in the transformer output as a not nullable field.So the records with null values are getting dropped.So in this case if you want null value just declare it as nullable. Or if you want it as not nullable then you can handle the null with null to empty or null to value function in the transformer.
Soumya
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am