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



What is the difference b/w natural key and surrogate key..

Answer / 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

More Informatica Interview Questions

why we use stored procedure transformation?

4 Answers   IBM,


where to store informatica rejected data?

0 Answers  


How to elaborate tracing level?

0 Answers  


What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,


How an expression transformation differs from aggregator transformation?

0 Answers  


What is Datadriven?

2 Answers   Informatica,


what is the difference between onsite & client site?

1 Answers  


Do you find any difficulty while working with flat files as source and target?

0 Answers  


Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  


Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,


what is the difference between Informatica7.1 & informatica 8.1

4 Answers  


What are the ETL tools available in DWH?

6 Answers   Mphasis,


Categories