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
- 8250 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
What are the transaction properties?
How many types of stored procedures are there in sql server?
What does this statement do @@rowcount?
What is the use of nvl work?
what is an index? : Sql server database administration
Can we insert data into a view?
Can another user execute your local temporary stored procedures?
What is an etl file?
What are the advantages of using third-party tools?
What is a livelock?
How to backup encryption key ?
What is a cache in ssrs?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
Explain what are various ways to enhance the ssrs report?
What does it mean to invest in the index?
