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