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 |
How you trouble shoot when any job fails
What is wrong with sql server client libarary dll, ntwdblib.dll?
How to test subquery results with the exists operator?
Difference between Triggers and Stored Procedure
23 Answers Claimat, HCL, Protech, Silgate,
What’s the distinction between dropping a info and taking a info offline?
which backup strategy you are following at ur company
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is de-normalization in sql database administration? Give examples?
Do you know what are the differences between lost updates and uncommitted dependencies?
What are the different types of joins and what does each do?