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

Explain what is the difference between native sql and cognos sql?

986


What is the use of report studio?

1013


Can you define pivot?

1074


How create measures and demensions?

1020


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

1995


difference between impromptu and cognos8

2416


What is Online View?

1933


What are the advantages of cognos?

966


What is the use of cognos decision stream?

1075


Define query studio?

978


How to generate cubes in cognos?

951


What are the components of the report studio?

1161


what is the procedure for scheduling conditional rendering?

2503


What are the advantages of using cognos sql?

1177


What is a Query Subject?

1071