Hi All,
I am trying to join 2 files based on key1(int) and key2(varchar), its not finding a match when I use both as keys although I can manually see the file and finds a match. if I remove key2 its working on Key1 but key2 is required. I tried trimming both keys in both files but still no match. Both files are generated from oracle table and I have $apt_oracle_preserve_blanks as false. I tried both lookup and join with sort, still not working.
Can any one help me on this..
Thanks in advance
Join issue
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
Join issue
hi sam here
Also try a test running just a 1-node configuration, as joins are commonly erroneous when incorrect partitioning is used.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
1- check that your column have the same format in your 2 inputs
integer must join and integer and a varchar join a varchar
2-check your partitionning and your sorts.
you're are right if the partitionning and the sort are the same of the join key and in the same order
3- Insert copy before your inputs and output data with peek to see what is the real data and transform them if necesary
Martin.
integer must join and integer and a varchar join a varchar
2-check your partitionning and your sorts.
you're are right if the partitionning and the sort are the same of the join key and in the same order
3- Insert copy before your inputs and output data with peek to see what is the real data and transform them if necesary
Martin.