Answer Detail: RE: Surrogate Key

GeekInterview.com > Interview Questions > Data Warehousing

Print |

Question: Surrogate Key

Answer: Why do we use Surrogate Key?

November 11, 2008 17:38:50	#1
developer_veni	Member Since: October 2008 Total Comments: 2
RE: Surrogate Key
Surrogate key: It is the system generated key which cannot be edited by the user. It is the primary key of the dimension table in warehouse. It is nothing but the sequence which generates the numbers for primary key column.