Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?

Question Posted / ravis190784

Answers were Sorted based on User's Feedback



what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?..

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

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?..

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

Post New Answer

More SQL Server Interview Questions

How to create an multi-statement table-valued function?

0 Answers  

What is auditing in sql server?

0 Answers  

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

How to query multiple tables jointly?

0 Answers  

What is bit datatype and what's the information that can be stored inside a bit column?

1 Answers  

How to trouble shoot if unable to connect SQL Server

0 Answers  

How can you get @@error and @@rowcount at the same time?

9 Answers  

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

How to create a large table with random data for index testing in ms sql server?

0 Answers  

What is difference between createstatement and preparedstatement?

0 Answers  

Explain Geometry datatype in sql server 2008 with example

0 Answers   Infosys,

What is implicit cursors?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories