Data Warehousing Basics Question:
Download Questions PDF

Explain the data type of the surrogate key?

Answer:

Data type of the surrogate key is either integer or numeric or number

There is no data type for a Surrogate Key.
Requirement of a surrogate Key:UNIQUE
Recommended data type of a Surrogate key is NUMERIC.

Download Basics Data Warehouse Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Differences between star and snowflake schemas?What is a CUBE in datawarehousing concept?