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


Please Help Members By Posting Answers For Below Questions

What is an active transformation?

623


what is INFORMATICA TESTING process

1814


What is deployment group?

662


What is the status code in stored procedure transformation?

664


Can we change Dynamic to Static or Persistent cache? If so what happens?

1694






what is the hint? how to use it to reduce the query processing in program?

6190


What is the advantage of informatica?

624


Did u used latest transformations of 8.6.0? for what?

1458


Explain the code page compatibility?

617


Briefly define a session task?

566


In development project what is the process to follow for an etl developer from day1

1259


How to do the error handling of if ur source is flatfiles?

1483


Explain constraint based loading in informatica

635


What is workflow monitor?

568


difference between repository database and repository service?

595