what is the purpose of surrogate key and diff between primary
key&surrogate key
Answer Posted / suresh
primary-key:-
It represents one or more fields or attributes that uniquely identified each record in a database table.
surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.
Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is sq transformation?
What is an expression transformation?
How do you change a non-reusable transformation to reusable transformation?
Enterprise data warehouse your projects phase by phase explain?
Whats there in global repository
update strategy transformation in informatica
What is a sorter transformation?
What is deployment group?
what are the deliverables?in your project?
I have a flat file, want to reverse the contents of the flat file
How do you migrate data from one environment to another?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the main features of Oracle 8i with context to datawarehouse?
How to use pmcmd utility command?
What is the fact table?