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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1988


How we check the errors before running the report?

1011


how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2117


----------------Describe DWH Architecture?

2076


It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2446


----------------Diff b/w Dimensional modeling and Relational modeling?

15019


Can you explain a cognos controller?

1033


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3619


Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2770


What are the advantages of cognos?

987


-----------Diff b/w OLAP and RDBMS?

2060


Please explain the different stages in creating a report in cognos report net?

1013


Can you define cognos powerplay?

1102


What are the types of studio present in Cognos?

1045


what are the special features in cognos reportnet?

1074