The store records have different effectivefrom and EffecttiveTodate. I ahve to load data that matches both the records in my facts.So if the user selects date that is within the 1st store range.It will show data for 1st record else the second store record. I cannot achieve this through lookup is it because it is syncronous.It Does not produce multiple records.