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

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  


what is the difference between filter and condition?

0 Answers   IBM,


Hi Friends, Please tell me at What situations we use the Segment, Link in FM, What is the Main Difference functionality wise? Thank You

1 Answers  


how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?

2 Answers   HCL,


tell me the creation of Snapshots?

2 Answers  


Explain the difference between powerplay transformer and power play reports?

0 Answers  


how u publish the packages in framework manager

3 Answers   TCS,


What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,


Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me

2 Answers  


Give the advantages of cognos?

0 Answers  


i was asked what are the caluclations done by you in your report? plz give reply

0 Answers   IBM,


Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.

2 Answers  


Categories