What is the difference b/w natural key and surrogate key
- 1 Answers
- 4734 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
How identifying bottlenecks in various components of informatica and resolving them?
Could you explain what is enterprise data warehouse?
What are different types of transformations available in informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the types of caches in lookup? Explain them.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
To import the flat file definition into the designer where should the flat file be placed?
Which version configuration tool used in ur project?
What are the types of schemas we have in data warehouse and what are the difference between them?
write a query to retrieve the latest records from the table sorted by version(scd)
What is informatica?
Explain lookup transformation source types in informatica
Separate from a database, an information bazaar, and an information stockroom?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Scheduling properties,whats the default (sequential)
