Hi all,
I have job design where data is written to seq file with "UNKNOWN" whwerever null is coming from the source.
While reading the file given null field value='UNKNOWN' in format tab so this will convert all 'UNKNOWN' data to null in seq file.
My source data coming as 'UNKNOWN' ,so my confusion is do 'UNKNOWN'(Src null) match with seq. file data i.e. null.
Regards
Prasoon
Null handling issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
I'm confused too.
If you are trying to compare non-file sourced data with 'UNKNOWN' as the value to that same value sourced from a file where you've converted that to null, then they won't match. Don't set the null field value if you want to compare them.
If you were asking something else, please... rephrase.
If you are trying to compare non-file sourced data with 'UNKNOWN' as the value to that same value sourced from a file where you've converted that to null, then they won't match. Don't set the null field value if you want to compare them.
If you were asking something else, please... rephrase.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 730
- Joined: Tue Nov 04, 2008 10:14 am
- Location: Bangalore