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...


what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...



what is the different between primarykey and surrogated key.. why we are going for surrogatekey.....

Answer / g.v

Primary key as all of u know this is a unique key,surrogate
key is a non -intelligent key which is used to replace a
composite key


we are going for surrogate key bcz suppose a person is
living in one city and then moved to other and the person
id is a primarykey.we need to update the location then we
need to add the updated record but the primary key wont
accept to add the record again for this purpose we will go
for surrogate key

Is This Answer Correct ?    9 Yes 0 No

Post New Answer

More Cognos Interview Questions

How can we do the unit testing?

3 Answers   Logica CMG,


difference between imprompt and reportnwt1.1

2 Answers   HSBC,


What is the abrevation of .PPR? (Power play report) or anything new?

1 Answers  


What is a Transformer?

0 Answers  


Can you define report item?

0 Answers  


When You Import data into catalog You have complex columns names. How do you change the Name of those columns?

2 Answers  


What errors and types of errors you faced in Cognos ReportNet?

1 Answers  


What is the difference between low affinity and high affinity connections?

0 Answers  


What is the information present in the cognos configuration file?

0 Answers  


Is there any comparison available for Cognos Reportnet Vs Crystal reports?

0 Answers   IBM,


How many types of models are present in cognos.?

4 Answers  


how many types of keys are there i.e primary key and foreign key etc..?

2 Answers   IBM,


Categories