As DS1 and DS2 is left outer join. The column coming from DS2 i.e Key_Col is giving null value. Though matching data exists, Key_Col is populating with NULL value which is wrong.
Thanks,
Rachitha
Join behaves strangely
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No Ray, Key_Col is not a join key field.
Applied hash partition based on key column, giving sorting, case sensitive, perform nulls first.
Still same problem exist..
AM not understanding y it is working in dev. environment but not in TEST env. what might be the reasons
Will it be a environment issue.. if yes what kind of issue it can be..
Should we check the number of nodes given in config file???
Thanks,
Applied hash partition based on key column, giving sorting, case sensitive, perform nulls first.
Still same problem exist..
AM not understanding y it is working in dev. environment but not in TEST env. what might be the reasons
Will it be a environment issue.. if yes what kind of issue it can be..
Should we check the number of nodes given in config file???
Thanks,
Rachitha
Thinking is the best way to train our brain!
Thinking is the best way to train our brain!