Hi,
There are few fields having nullable in source.
In target I have those fields nullable too. Do I need to handel those fileds, if my source value is null, in Parallel Extender?
Nullability in Px
Moderators: chulett, rschirm, roy
No need to handle them at all. The only issue is when you try to write a null to a non-nullable column.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Hard to answer that question, as you haven't specified what the "issue" is. Much of the time problems are encountered in transformations, where you get warnings or error when trying functions on null values.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Nope.. The second question wasn't for you...
I need to get it clarify from my team.. they are continuously asking me, how are we handling nullability in the project... and we are not handling in any way b'coz all target fileds, possible of getting null value, are nullable.
And from your answer i got clarified.. now let me ask them..
I need to get it clarify from my team.. they are continuously asking me, how are we handling nullability in the project... and we are not handling in any way b'coz all target fileds, possible of getting null value, are nullable.
And from your answer i got clarified.. now let me ask them..
Thanks,
Yuva.
Yuva.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Your big issue with nulls in parallel jobs is whether you are using them in a lookup or transformation logic. If you pass a nullable source field straight through to a nullable target then you wont have a problem. If you try to run any type of Transformer trim, IF statement, compare, parse etc on it then whenever it has a null value in it you could lose that row - it could get spat out of your job. If you have nullable fields and you want to do something to them in a transformer you need to have a NullToValue around them first before you do anything else.
Unless you have profiled your data source and check the source application business rules and determined that the field is nullable but will never be null.
Unless you have profiled your data source and check the source application business rules and determined that the field is nullable but will never be null.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
I think your team's concern is more of a 'business type' rather than technical. Get this piece clarified.
At some shops, they want insane error handling even though it does not make sense. But at the least, make sure you are capturing the records that are getting rejected by the database due to nullability, or for any reason for that matter.
At some shops, they want insane error handling even though it does not make sense. But at the least, make sure you are capturing the records that are getting rejected by the database due to nullability, or for any reason for that matter.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.