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
What is the function of look up transformation?
Mention few power centre client applications with their basic purpose?
explain about unit testing? in real time?
can you please explain me pre session and post session options?
What is meant by active and passive transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is substr in informatica?
What is the difference between Active and Passive transformation?
What is meant by pre and post session shell command?
Repository user profiles
what are the deliverables?in your project?
What is the need of an ETL tool?
What is fact table? Explain the different kinds of facts.
How do you remove duplicate records in informatica? And how many ways are there to do it?
What is a filter transformation?