Hi,
sometimes i am getting warning messages a lot(same warning message).
For example.
APT_CombinedOperatorController(0),0: Null string argument.
Above warning message repeating multiple times.
Is there any technique to limit 2 or 3 warning messages?
Warning message limit
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
you have not handled for the columns for which you are getting null from the source. Try one of these solutions:
1. Use IsNull() or IsNotNull where ever required in Transformer.
2. Also if your target is a seq file then Use Null field value constraint and make equal to ''. thats it
3. If you just want to limit the number of warnings then you can add a message handler constraint inthe Director as well.
1. Use IsNull() or IsNotNull where ever required in Transformer.
2. Also if your target is a seq file then Use Null field value constraint and make equal to ''. thats it
3. If you just want to limit the number of warnings then you can add a message handler constraint inthe Director as well.
Thanx and Regards,
ETL User
ETL User