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 are the tasks that source qualifier perform?
What if the source is a flat-file?
What are the designer tools for creating transformations?
What is a standalone command task?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
what is the hint? how to use it to reduce the query processing in program?
What is the difference between STOP and ABORT options in Workflow Monitor?
Under which circumstances, informatica server creates reject files?
How would you copy the content of one repository to another repository?
What is source qualifier transformation in informatica?
what are 3 tech challenges/ common issues you face?
How many ways are there to do 'remove duplicate records in informatica'?
Tell me about MD5 functions in informatica
lookup transformation with screenshots
what is informatica metadata?