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 an active transformation?
what is INFORMATICA TESTING process
What is deployment group?
What is the status code in stored procedure transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
what is the hint? how to use it to reduce the query processing in program?
What is the advantage of informatica?
Did u used latest transformations of 8.6.0? for what?
Explain the code page compatibility?
Briefly define a session task?
In development project what is the process to follow for an etl developer from day1
How to do the error handling of if ur source is flatfiles?
Explain constraint based loading in informatica
What is workflow monitor?
difference between repository database and repository service?