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.

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

Do you know what are the restrictions that views have to follow?

0 Answers  

---

What is join and name different type of joins?

0 Answers  

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

in how many ways we can use count()

2 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---

what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,

---

How to create new tables with "select ... Into" statements in ms sql server?

0 Answers  

---

What are the system database in sql server 2008?

0 Answers  

---

How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---