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.

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.

What is the security principal at the server level that represents your session?

0 Answers  

---

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

What are sql servers used for?

0 Answers  

---

Does partitioning ssd reduce performance?

0 Answers  

---

Where cross join is used?

0 Answers  

---

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

Difference between sql server 2000 and sql server 2005?

11 Answers   Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

---

What is standby servers? Explain types of standby servers.

0 Answers  

---

What are subqueries in sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2008

0 Answers   TCS,

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---