Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference b/w natural key and surrogate key
- 1 Answers
- 5454 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 is the benefit of session partitioning?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a surrogate key?
What is the function of look up transformation?
Enterprise data warehouse your projects phase by phase explain?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Different circumstance which drives informatica server to expel records?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain the informatica workflow?
What is a standalone command task?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How many transformations can be used in mapplets.
How is union transformation utilized?
