Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference b/w natural key and surrogate key
- 1 Answers
- 5482 Views
- I also Faced
- E-Mail Answers
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 are the types of lookup transformation?
What do you mean incremental aggregation?
How might you approve all mappings in the archive all the while?
What is the difference between informatica 7.0 and 8.0?
4 yrs etl devloper roles and responsibilities?any body give solutions
What does update strategy mean, and what are the different option of it?
Explain the tuning lookup transformation - informatica
What are batches?
What are the different types of olap? Give an example?
According to his methodology what all you need before you build a datawarehouse
What is workflow monitor?
How to create the source and target database connections in server manager?
How can we handle two sessions in informatica?
What is a connected transformation?
How we can create indexes after completing the load process?
