Posted 19 Mar 2012
There are data models that use surrogate keys as part of primary key/primary index definition. Examples are: Industry and Homegrown models. The use of surrogate keys is usually considered when loading different source systems with different natural keys on the same integrated data model. This implies a conversion of the different natural keys into a standard surrogate key that can be used for all source systems. |
CPU and I/o remains the same but I am quite unsure about the TAT time.
|