Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference b/w natural key and surrogate key
- 1 Answers
- 5488 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 components of the workflow manager?
Explain the scenario which compels informatica server to reject files?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is a mapplet/worklet in informatica?
Define mapplet?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Sequence generator, when you move from develoment to production how will you reset
What are Dimensional table?
What is the difference between a repository server and a powerhouse?
What does refresh system mean, and what are its distinctive choice?
Differentiate between a repository server and a powerhouse?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Explain the etl program with few examples.
Have you worked with/created Parameter file
What is a code page?
