EE Lookup Stage VS Server Transformer
Posted: Wed Apr 11, 2007 9:21 pm
Hi Guys! Just a lil' curious.
Currently, my project involves utilizing server jobs.
The design is like this. I have a sequential file (main flow),
columns:
1) Customer ID
2) Name
and a lookup hash file (Which serves as independent lookup)
columns:
1) Area ID
2) Address
Utilizing a transformer to do output assignment, my hash file serves as an independent lookup, whereby it does not do any sort of key join with the main flow.
In the hashfile lookup flow, by the 'Address' column, I pre-input the value '56, Washington Street' in the Key Expression column.
What happens is, Area ID (Only related to 56 Washington Street), will be outputted into the output flow. Which means all records from the sequential file will eventually contain the Area ID pertaining to 56 Washington Street.
Can I perform the exact same independent lookup like the above with the 'Lookup Stage' in a parallel job? Or is lookup stage's function is to perform dependent lookups with main flows?
Please advice. Many thanks! =)[/img]
Currently, my project involves utilizing server jobs.
The design is like this. I have a sequential file (main flow),
columns:
1) Customer ID
2) Name
and a lookup hash file (Which serves as independent lookup)
columns:
1) Area ID
2) Address
Utilizing a transformer to do output assignment, my hash file serves as an independent lookup, whereby it does not do any sort of key join with the main flow.
In the hashfile lookup flow, by the 'Address' column, I pre-input the value '56, Washington Street' in the Key Expression column.
What happens is, Area ID (Only related to 56 Washington Street), will be outputted into the output flow. Which means all records from the sequential file will eventually contain the Area ID pertaining to 56 Washington Street.
Can I perform the exact same independent lookup like the above with the 'Lookup Stage' in a parallel job? Or is lookup stage's function is to perform dependent lookups with main flows?
Please advice. Many thanks! =)[/img]