Tuesday, March 19, 2013

Difference between Surrogate key and Primary key?

Surrogate key:
  1. Query processing is fast.
  2. It is only numeric
  3. Developer develop the surrogate key using sequence generator transformation.
  4. Eg: 12453
Primary key:
  1. Query processing is slow
  2. Can be alpha numeric
  3. Source system give the primary key.
  4. Eg: C10999

No comments:

Post a Comment