Interested to Buy Any Domain ? << Click Here >> for more details...
what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
- 2 Answers
- 8290 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh s. chandan
Unique identitiy key is generated during data load process
(ETL) in the datawarehouse system is called as Surrogate
key.
It is mainly used to update slowing changing dimesion
attribute data and also it removes dependencies on key
originating in different data sources.
Primary key is uniquely identified each record in a table
with no null values.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to verify a user name with sqlcmd tool?
How do I completely remove sql server instance?
How to create a user to access a database in ms sql server using "create user" statements?
What is the use of “join” in sql server?
What happens if null values are involved in comparison operations?
How network traffic be reduced by using the stored procedure?
Where is my database stored on the hard disk in ms sql server?
What is normalization and its types?
What is the difference between commit and rollback?
How to delete all rows with truncate table statement in ms sql server?
What is the sql server 2000 version number?
What is query optimization process?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
What is the Main Difference between ACCESS and SQL SERVER?
How to get a list of columns in a view using the "sp_help" stored procedure?
