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

Is it possible to apply access manager user rights in impromptu?

1 Answers  


How many types of models are present in cognos.?

4 Answers  


What is difference between data mart and data warehouse?

0 Answers  


if there are list,crosstab,chart how can you apply a single filter to all object?

3 Answers   IBM, Syntel,


what was the actual purpose of portfolio in cognos ?

1 Answers  


How to a create header dynamically in a crosstab report in cognos 8.1?

0 Answers  


what are summary filters? grouped filters?

3 Answers   IBM,


Wt is the Diff between Business Key & member caption?

2 Answers  


What is the deployment requirements used in cognos?

0 Answers  


---------- Purpose of Factless Facttable?

2 Answers   Bank Of America,


please tell me architecture of the cognos8?

4 Answers   IBM, TCS,


suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me

2 Answers  


Categories