what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
- 2 Answers
- 7369 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
Can an entity have two primary keys?
What the different types of Replication and why are they used?
What are the different types of replication you can set up in sql server?
How do you handle datasets larger than 50 gb?
Write a program using SQL queries to find a unique entry in a table.
What does asynchronous call backs means?
How to get the number of affected rows?
What is the default port for SQL Server over a firewall?
Where can you find the error log information? : sql server database administration
What stored by the model? : sql server database administration
What is report subscription?
What types of replication are supported in sql server?
What is the difference between Stored Procedures and triggers?
What do you mean by table and field in sql?
What is sub-query in sql server?
