What is the difference b/w natural key and surrogate key
- 1 Answers
- 4709 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the Differences between static cache and dynamic cache?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the reusable transforamtions?
How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.
Can you access a repository created in previous version of Informatica?
How to use procedural logic inside infromatica?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in
draw informatica architecture 8.6 ?
Explain direct and indirect flat file loading (source file type) - informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Teradata 
