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
- 8373 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 happens to a statement batch if there is a compilation error?
Explain index in sql server?
Tell me something about security and sql azure?
What is the difference between for trigger and after trigger?
is there a column to which a default can't be bound? : Sql server database administration
Define a cross join?
what is datawarehouse?
What does select 1 mean?
How to maintain a fill factor in existing indexes?
Write a SQL command to insert and update only a particular field?
Define left outer join in sql server joins?
What guidelines should be followed to help minimize deadlocks?
Does index speed up select statements?
What is replication and database mirroring?
can a database be shrunk with users active? : Sql server administration
