what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jayaraj
Primary key is a type of key where the data inside the
column should be unique and should not be null.we generally
use the primary key to access any of the rows of a table by
using the primary key column.when a table don't have a
primary key then we assign a primary key to the table which
is known as surrogate key for accessing any row of the
table. means the key will act like a primary key for the
table.
Is This Answer Correct ? | 4 Yes | 16 No |
What are wait types?
How much space does sql server 2016 take?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Hi..here i would like to know the Backup and Restore models?
Wht is Stuff in sql ser
What are the different subsets of sql?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What is an extended Stored Procedure?
Explain stored procedure?
Does a server store data?
How to use transact-sql statements to access the database engine?
How can change procedure in sql server?