I need to do a following thing in Server Job
Problem : If a value for a Particular Column is A.
then i need to do a lookup with a hash file. If it is not found or if the say COLUMN <> A,
then i need to do a lookup once again with another Hash file B , then Combine the Flows together and do further Processing.
For the Above Problem
I have used following Logic to Build
..........................HASH 1
SplitTrans -------> Trans1--------->Found
|...................................................|
|<-----------------NotFound.............Collector2----->FurtherTrans
Collector1.......................................|
|-------------------->Trans2------->Found
............................HASH2
Solution Used :
1) SPLIT TRANS for COLUMN =A and COLUMN <> A.
2) Then those records which failed lookup with Trans1 and Column<> a from Split trans (Used Collector1 stage to collect) and then go for a lookup with HASH2.....
3) Used Collector2 for succesful lookups of TRans1 and Trans2 Succesful lookups to again collect in Collector to send to FurtherTrans for further Transformations....
Phew!!!!!!!!! .
I guess ppl shld have understood the Logic.
So I am doing the Above stuff with Link Collectors.
Does it lead to any Performance Issues ????????
Or is there any Better way of Doing the Above Problem...
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)
![Confused :?](./images/smilies/icon_confused.gif)