How to populate fact table with Surrogate keys from dimensions?

Question

Could someone please help me understand how to populate the fact table with Surrogate keys from dimensions using SSIS? I load my dimension tables and assign for each a surrogate key. I want to add these surrogate keys to my fact table but I don't know from where to start.

NickW · Accepted Answer · 2022-01-26 20:25:14Z

1

You just join your fact source record to the relevant dimension tables and get the surrogate keys, which you then insert into your fact table

answered Jan 26, 2022 at 20:25

NickW

10k2 gold badges10 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to populate fact table with Surrogate keys from dimensions?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related