Monday, October 22, 2012

Differences between Surrogate Key and primary Key


Differences 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