DSXchange

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

You can use a lookup stage to do a range lookup.