What is the difference b/w natural key and surrogate key
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 |
why we use stored procedure transformation?
where to store informatica rejected data?
How to elaborate tracing level?
What are the issues you have faced in your project? How did you overcome those issues?
How an expression transformation differs from aggregator transformation?
What is Datadriven?
what is the difference between onsite & client site?
Do you find any difficulty while working with flat files as source and target?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
what is the difference between Informatica7.1 & informatica 8.1
What are the ETL tools available in DWH?