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
How many dimensions are there in informatica?
What are the mapping parameters and mapping variables?
What are the advantages of informatica?
How would you join a node to the already existing domain?
Explain how to import oracle sequence into informatica?
Reusable transformation and shortcut differences
how to load rows into fact table in data warehouse
wf dont have integration severances how you can run?
What is informatica etl tool?
Sequence generator, when you move from develoment to production how will you reset
How do you manage the Parameter files while migrating your data from one environment to another environment?
difference between informatica 8.1.1 and 8.6
What do you mean by worklet?
How can we use mapping variables in informatica?
What is olap (on-line analytical processing?