question

tlenzmeier avatar image
tlenzmeier asked

What's the best method for looking up dates in SSIS for a fact table?

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?

ssislookupsdatawarehouse
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.