Hi,
I was trying to do Range lookup to a SCd type 2 table where I was trying to get values from reference link based on Transaction_Code/Transaction_Date combination.
Since the unique key combination in reference link is Transaction_Code and Effective_date, it was must to define both as key columns in reference link else the lookup stage was skipping other records. When I made Effective_Date a part of key column, it enforced me do a equijoin lookup on Effective_Date also. I was not able to perform range lookup on date columns.
Does that mean we can not Range lookup for a date that is part of unique key or in other words we can not do lookup on Type 2 table?
Thanks,
Shashank
Range Lookup
Moderators: chulett, rschirm, roy