Use of Hashfiles in a parallel job
Posted: Fri Jul 13, 2007 9:19 am
Hi All,
I am developing a parallel job which need to perform a lookup on a huge database table. The lookup involves 2 key columns and 1 data column (about 30 bytes in total) and about 10 million rows?
What kind of lookup mechanism is advisable for this job? How can I decide whether to use a ODBC lookup stage or a hashfile in this job?
Also, first of all, can hashfiles be used in parallel jobs in datastage or is it not advisable/available?
Thanks in advance
Venkatesh
I am developing a parallel job which need to perform a lookup on a huge database table. The lookup involves 2 key columns and 1 data column (about 30 bytes in total) and about 10 million rows?
What kind of lookup mechanism is advisable for this job? How can I decide whether to use a ODBC lookup stage or a hashfile in this job?
Also, first of all, can hashfiles be used in parallel jobs in datastage or is it not advisable/available?
Thanks in advance
Venkatesh