less rows from lookup
Moderators: chulett, rschirm, roy
less rows from lookup
Hi
I have source file and lookup file which are joined using trnasformer.
I am getting data for lookup from oracle table the problem i ma facing is
When i try to run the job for lookup individually using oracle and hash file for lookup i am getting exact rows as in database even after applying where clause.
But when i joined this lookup with source i ma getting less rows from lookup which was not like that when the lookup individually.
can u pls let me know why am i getting less number of rows after join with source where as i am getting same number of rows when ru the job individually for lookup.
pls help me here
I have source file and lookup file which are joined using trnasformer.
I am getting data for lookup from oracle table the problem i ma facing is
When i try to run the job for lookup individually using oracle and hash file for lookup i am getting exact rows as in database even after applying where clause.
But when i joined this lookup with source i ma getting less rows from lookup which was not like that when the lookup individually.
can u pls let me know why am i getting less number of rows after join with source where as i am getting same number of rows when ru the job individually for lookup.
pls help me here
RD
I am not sure where the hashed file fits in. But which lookup is not working and can you identify a row which should be found in the lookup but is not?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What is the data type of the lookup (reference) key? Are you certain that you trimmed trailing space when loading the hashed file and when you form the reference key value?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi
I have the column flieght_sched_key in my table and hash file with value
2405269
but i am unable to find the key value for 2405265 in hash file where as same exist in my table.
Column data type is integer and i am not doing any trimming on this column.
can you pls help me why i am uanble be view the rwo with key 2405265 in hash file.
I have the column flieght_sched_key in my table and hash file with value
2405269
but i am unable to find the key value for 2405265 in hash file where as same exist in my table.
Column data type is integer and i am not doing any trimming on this column.
can you pls help me why i am uanble be view the rwo with key 2405265 in hash file.
RD
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 27
- Joined: Wed Jan 03, 2007 1:29 am
-
- Participant
- Posts: 27
- Joined: Wed Jan 03, 2007 1:29 am
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 147
- Joined: Sat Apr 30, 2005 1:23 am
- Location: Bangalore,India
-
- Participant
- Posts: 27
- Joined: Wed Jan 03, 2007 1:29 am
I had a similar problem where my hash file had 3 keys in which the key cols were not continuous from the start. So if a transformer is not used when data is transfomed to hash file then it would give problem if the keys are not continuous from the start. So try giving the key column as the first column in the hash file. I believe this should solve the issue.
Hemachandra