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.

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

How to drop an existing schema in ms sql server?

0 Answers  

---

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

0 Answers   TCL, Wipro,

---

what authentication modes does sql server support? : Sql server database administration

0 Answers  

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

What is the use of =,==,=== operators?

0 Answers  

---

hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju

4 Answers  

---

How to test subquery results with the exists operator?

0 Answers  

---

What is a result set object returned by odbc_exec()?

0 Answers  

---

Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

What are xml indexes?

0 Answers  

---