null handling warning
Moderators: chulett, rschirm, roy
null handling warning
How can I get rid of warnings comming from my lookup stage teling me no null handling has not been set up for fields that can have null values? Thanks for your help. I have a sequncer that should fail with warning, but not the "no null handling" warnings. Is there a way to turn off the null handling warnings?
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
Since i don't have access to DS at this moment, i could not tell you more precisely. If you don't have that feature in the stage you are using, use Message Handler to demote the warning to informational message. Then your sequence would not abort for this particular warning.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
Demoting the message to informational is not going to help you, since the warning is most likely occurring in the sequential file write stage and any rows with one or more nulls will not get written to the output unless you handle nulls. You will need to handle nulls for all nullable columns when writing to a sequential file.
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India