![Embarassed :oops:](./images/smilies/icon_redface.gif)
rule: Only load the records where main_id = lookup_id
and dt_record between dt_start and dt_end.
- main input I have main_id and dt_record
- lookup input I have lookup_id, lookup_desc, dt_start and dt_end.
- target I have main_id, lookup_desc and dt_record
for example:
main input
main_id dt_record
1 10/10/2005
2 10/10/2005
3 10/09/2005
lookup input
lookup_id lookup_desc dt_start dt_end
1 AAA 01/01/2005 10/07/2005
1 BBB 10/08/2005 01/10/2005
1 CCC 02/10/2005 10/01/2006
if I have this sources, what I shoud load in the target is:
main_id lookup_desc dt_record
1 CCC 10/10/2005
Additional info:
main input -> store procedure Sql Server
lookup input -> hashed file(all the columns in the hashed file is key)
I would like to know what key expression should I put in the transformer?
Regards,
Fernando