Oracle_Src_Nxrp_Trn_Vce_Avl_Dtl: When checking operator: When binding output interface field "TIME_KEY" to field "TIME_KEY": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
We use all the keys as not null column in both source stage as well as the target stages.We are try to eliminate this warnings by introducing modifier stage.Still it is not poss.....share ur ideas to avoid this warnings
Remove the warnings
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 28
- Joined: Mon Nov 06, 2006 5:44 am
- Location: chennai
-
- Participant
- Posts: 222
- Joined: Tue Aug 30, 2005 2:07 am
- Location: pune
- Contact:
Hi,
I think, you have to check your flow once again.Any where, by mistakenly you have different nullability of field TIME_KEY from source to target. The warning saying that, handle those null, its suggesting that use modify stage for this purpose.Check the your source data also for the field TIME_KEY.
One more possibility is if you are perofrming lookup or join to get the filed TIME_KEY. Then check, if lookup fails it will give the null value to u r filed.
I think, you have to check your flow once again.Any where, by mistakenly you have different nullability of field TIME_KEY from source to target. The warning saying that, handle those null, its suggesting that use modify stage for this purpose.Check the your source data also for the field TIME_KEY.
One more possibility is if you are perofrming lookup or join to get the filed TIME_KEY. Then check, if lookup fails it will give the null value to u r filed.
NageshSunkoji
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
If you know anything SHARE it.............
If you Don't know anything LEARN it...............
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: