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

Define Foreign Key?

3 Answers   ADP, College School Exams Tests,

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

What is scd (slowly changing dimension)? : sql server analysis services, ssas

0 Answers  

Explain about merge replications?

0 Answers  

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

How will you make an attribute not process? : sql server analysis services, ssas

0 Answers  

What are group functions in query statements in ms sql server?

0 Answers  

What is the difference between system objects and user objects?

0 Answers   HCL,

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

3 Answers  

What are the tool windows in sql server management studio? : sql server management studio

0 Answers  

IN Vs OR operator which is best to use sql server.

4 Answers  

Explain intellisense for query editing

0 Answers  

For more SQL Server Interview Questions Click Here
Categories