Surrogate Keys

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Surrogate Keys as PDF --


Surrogate keys are used to join fact tables to dimensions. Surrogate keys isolate the data warehouse from changes to the operational systems, help in integrating data into dimensions coming from different sources and offer good performance when used in joins as they are simple integers. Lastly, they are used in tracking changes in dimension tables.

Click here for example

 

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*