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