Hashed File Vs Routine...Performance Question ?
Posted: Fri Mar 31, 2006 10:29 am
Guys
I would like to know which one will perform better for the below given scenorio.
Say I have a file with 500,000 records and each record has 10 columns.
Out of the 10 columns 4 columns need to be validated.
I have a hashed file with one record for each coulmn validation rule.
Scenario 1
----------
My DS Job is like this...I have four links from Hashed file as there are 4 fields need to be validated.
Scenario 2
----------
Here instead of doing a look up in a hashed file, I use a routine to do the same(passing value to routine and get the value back).
My question is which approach will be fatser ?
Thanks
I would like to know which one will perform better for the below given scenorio.
Say I have a file with 500,000 records and each record has 10 columns.
Out of the 10 columns 4 columns need to be validated.
I have a hashed file with one record for each coulmn validation rule.
Scenario 1
----------
My DS Job is like this...I have four links from Hashed file as there are 4 fields need to be validated.
Code: Select all
Hashed File
| | | |
| | | |
| | | |
seq file------->Transformer--------->Seq file
----------
Code: Select all
seq file------->Transformer--------->Seq file
My question is which approach will be fatser ?
Thanks