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
- 8159 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 is the difference between Delete and Truncate command in SQL
What is 5nf in normalization form?
What are the different types of sub-queries?
Explain alternate key, candidate key and composite key in sql server?
What it means to be triggered?
What is the process of normalization?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
Can a function call a stored procedure in sql server?
Where the sql logs gets stored? : sql server database administration
What is pivot and unpivot?
What is the purpose of the model database?
What is shrink log file?
What are distinctive joins find as a part of sql?
What is used to replicate sessions between instances in coldfusion clusters?
What are commonly used mssql functions in php?
