Forum Discussion
Lookup table that changes over time
palpeti21 wrote:Thanks, this is very helpful. I will probably need to use Type 2 - Row Versioning. My next issue then is with this method I will no longer be able to use the customer ID, I'll need to use the Surrogate Key to connect to my fact table. I don't have a match for these in the fact table though...
You are right. You will need a surrogate key and your fact table ETL (extract, transform, load) process also needs to be modified to populate the right surrogate key in the fact table.
If your question has been answered, please mark the post as answered.
Thanks, this is very helpful. I will probably need to use Type 2 - Row Versioning. My next issue then is with this method I will no longer be able to use the customer ID, I'll need to use the Surrogate Key to connect to my fact table. I don't have a match for these in the fact table though...
palpeti21 wrote:Thanks, this is very helpful. I will probably need to use Type 2 - Row Versioning. My next issue then is with this method I will no longer be able to use the customer ID, I'll need to use the Surrogate Key to connect to my fact table. I don't have a match for these in the fact table though...
You are right. You will need a surrogate key and your fact table ETL (extract, transform, load) process also needs to be modified to populate the right surrogate key in the fact table.
If your question has been answered, please mark the post as answered.