Hello,
I have a fact table that contains numerous dates. Right now I use multiple, sequential, lookups in SSIS to retrieve the primary key value. The source data stores all the dates as dates, e.g., 2021-12-06. Instead of having six sequential lookups, is there a better way to improve performance?
