What is the difference b/w natural key and surrogate key
- 1 Answers
- 4718 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
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Explain lookup transformation source types in informatica
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is the Process to creating lookup transformation in informatica
Explain the scenario which compels informatica server to reject files?
What is Index Caches size?
How do you take back up of repository?
What is the use of target designer?
Explain the aggregator transformation?
What do you mean by channel change?
Where is metadata stored?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
In informatics server which files are created during the session rums?
tell me about your project functionality
What is the difference between a repository server and a powerhouse?
