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 difference b/w natural key and surrogate key

Answer Posted / babulcity

Natural Key is key attribute column of an entity with
distinct values i.e without duplicates/NULL.
Eg: For natural Key we can define constraint like PK,FK

Surrogate Key is an substitute key which is not a part of
attribute of entity & is unique but it can be used to act as
PK,FK when you cannot use the Natural key.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many dimensions are there in informatica?

1135


What are the mapping parameters and mapping variables?

1272


What are the advantages of informatica?

1061


How would you join a node to the already existing domain?

1182


Explain how to import oracle sequence into informatica?

1071


Reusable transformation and shortcut differences

1884


how to load rows into fact table in data warehouse

1230


wf dont have integration severances how you can run?

1987


What is informatica etl tool?

1061


Sequence generator, when you move from develoment to production how will you reset

2127


How do you manage the Parameter files while migrating your data from one environment to another environment?

1069


difference between informatica 8.1.1 and 8.6

3732


What do you mean by worklet?

1117


How can we use mapping variables in informatica?

1125


What is olap (on-line analytical processing?

1112