regarding utility hashlookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
regarding utility hashlookup
Hi Gurus,
I read that utilityhashlookup does lookup operation against a hashtable.
my design is odbc------>hashed file.
used another odbc source and want to join with hashed file.
i want to make use of utility hashlookup which does lookup against a hashtable.
from where i should call this utility, so that it does lookup against the table stored in my hashed file.
cheers;
vijay
I read that utilityhashlookup does lookup operation against a hashtable.
my design is odbc------>hashed file.
used another odbc source and want to join with hashed file.
i want to make use of utility hashlookup which does lookup against a hashtable.
from where i should call this utility, so that it does lookup against the table stored in my hashed file.
cheers;
vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Transformer stage that you have not yet included in your design.
However, it would be far more efficient to use a second Hashed File stage in the job design, and use the Transformer stage to perform the lookup against it. In this way, you do not incur the overhead of the routine, and possibly gain the benefit of the hashed file read cache.
However, it would be far more efficient to use a second Hashed File stage in the job design, and use the Transformer stage to perform the lookup against it. In this way, you do not incur the overhead of the routine, and possibly gain the benefit of the hashed file read cache.
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.
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
hi gurus,
i need to make use of utilityhashlookup, i never used this utility.
i have seen from previous forums that it does lookup against hashtable.
i have dumped table for ex: employee in hashedfile.
from where i should call this utility.
i never used this utility, i want to make use of this utility and analyze how it works.
plz gurus i would appreciate if anyone help me in analyzing this utility.
cheers;
vijay
i need to make use of utilityhashlookup, i never used this utility.
i have seen from previous forums that it does lookup against hashtable.
i have dumped table for ex: employee in hashedfile.
from where i should call this utility.
i never used this utility, i want to make use of this utility and analyze how it works.
plz gurus i would appreciate if anyone help me in analyzing this utility.
cheers;
vijay
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You don't. It's the wrong answer to your requirement.vijaykumar wrote:i need to make use of utilityhashlookup
Source code is provided in the repository; examine it if you want to understand what it does and how it works.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 228
- Joined: Tue Oct 03, 2006 7:08 pm
HI GURUS,
my design is hashfile---->ODBC
combining hashfile with ODBC with transformer stage.
i want to make use of utilityhashlookup.
iam defining the properties at column deptno.
deptno-->doubleclick--->browse for functions and i specify the expression as UtilityHashLookup('SCOTT.DEPT', DEPTNO, DSLink15.DEPTNO).
i cannot validate my expression.
my keycolumn is deptno
my name of hashtable--->scott.deptno
i couldn't understand the term- position to be retained.plz help me in validating the expression and also in analyzing the utility.
cheers;
vijay
my design is hashfile---->ODBC
combining hashfile with ODBC with transformer stage.
i want to make use of utilityhashlookup.
iam defining the properties at column deptno.
deptno-->doubleclick--->browse for functions and i specify the expression as UtilityHashLookup('SCOTT.DEPT', DEPTNO, DSLink15.DEPTNO).
i cannot validate my expression.
my keycolumn is deptno
my name of hashtable--->scott.deptno
i couldn't understand the term- position to be retained.plz help me in validating the expression and also in analyzing the utility.
cheers;
vijay
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
Check this post, Ken had given a beautiful explanation. Search is a best approach for all your questions.
viewtopic.php?t=101154&highlight=utilityhashlookup
Sam
viewtopic.php?t=101154&highlight=utilityhashlookup
Sam