If you can have a look at the first and last record, it is evident that datastage is generating zero on some numeric field (in case of last record for employee id it was zeros and for salary it was null), junk on date/time and empty or NULL on varchar column. Please help to understand the behavior.
In most of the case, I have used a joiner stage set to do left outer operation and on down stream operation I find the inner join records (in away trying to capture the reject record out of joiner stage). In this case if datastage is dumping some junk value how can I handle this? Also a junk value in a date time field means on any downstream date time operation I have to check the validity of the date/time. I have used Oracle as the source. Please help to decode the way datastage give the output values on outer joins
Many Thanks
Murali Sankar R
The minute you start talking about what you're going to do if you lose, you have lost
Datastage defaults not nullable Integer fields to 0 whenever you use a Join (left outer or right outer) or LookUp stage and the data is coming from the non-master link or reference link.
It is always a good practice to use dummy/masked values when you provide examples rather than copying the data from your work place. The information you have provided in the example is sensitive and I would recommend you re-edit the post to mask your examples.
I've removed your code tagged example data due to concerns over exposing PHI/PII in the forums here. Please feel free to edit your post and replace your previous examples with something more appropriate - redacted / masked or completely made up values for example - for things like name, phone number, salary, etc.
Thanks.
-craig
"You can never have too many knives" -- Logan Nine Fingers
chulett wrote: I've removed your code tagged example data due to concerns over exposing PHI/PII in the forums here. Please feel free to edit your post and replace your previous examples with something more appropriate - redacted / masked or completely made up values for example - for things like name, phone number, salary, etc.
Thanks.
Thanks all. The data I have pasted is the employee and departments data out of standard oracle scott schema tables. It is not a real data!
The minute you start talking about what you're going to do if you lose, you have lost
Good to know and now that we know that, feel free to edit your post and replace it. I sent you what I removed in a personal message so you shouldn't even have to dig it up again.
-craig
"You can never have too many knives" -- Logan Nine Fingers