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

What are the types of lookup transformation?

1081


What do you mean incremental aggregation?

1077


How might you approve all mappings in the archive all the while?

1018


What is the difference between informatica 7.0 and 8.0?

1016


4 yrs etl devloper roles and responsibilities?any body give solutions

2168


What does update strategy mean, and what are the different option of it?

1092


Explain the tuning lookup transformation - informatica

996


What are batches?

1101


What are the different types of olap? Give an example?

1057


According to his methodology what all you need before you build a datawarehouse

1759


What is workflow monitor?

1062


How to create the source and target database connections in server manager?

1090


How can we handle two sessions in informatica?

1033


What is a connected transformation?

1119


How we can create indexes after completing the load process?

1160