I was just wondering if there is any way where I can have a lookup irrespective of what the hashfile key field is looked up against. In other words can I look up a hash File for a particular field(say to be used in transformer) in all circumstances and have that for manipulation of all the incoming streaming records from other link.
Basically it started like this.I have a simple rule something like 'Cost A/sum of all Costs A*100).In essence,I've to find % contribution of each cost against all. I tried using something like this
FlatFile-->Aggregator------------>HashFile
|Lkup
|
Copyof_FlatFile-->Trans1------->Trans2
|
|
Output File
And I wanted to lookup against the hashFile always where I'm collecting the sum of all CostsA; then I could have used it in Trans2. There is no 'primary key' in the source input file.
I'm stumped!
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Any answer for my Q. Or any better idea to do this otherwise simple looking thing in one job. Another way is to break up this into two jobs/b4 subroutine and use the output from there as input for this job.