Q
Problem solve Get help with specific problems with your technologies, process and projects.

What is a surrogate key?

What is a surrogate key in a table?

What is a surrogate key in a table?
A surrogate key is a system-generated (non-meaningful from a business perspective) primary key for purposes of ensuring uniqueness within a database table. Surrogates for DW are usually created during the Delta processing within the ETL layer. Uniqueness is usually driven by referencing one or more data elements from the source table that are considered proper rules for ensuring uniqueness. Surrogates are usually numeric data elements and many times will take advantage of the database sequencer object or the ETL tools sequence transformation object.
This was last published in November 2005

Dig Deeper on Oracle data warehousing

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close