Content deleted Content added
Line 45:
Choosing a specific technique to load/refresh your target system depends upon different factors:<br />
1. Amount of data updated/changed/added.<br />
2. Quality of data required i.e. How fresh data should be.<br />
For case 1: if the updated/changed/added data is > (in some cases equal to) 10% of the existing data then we are going to use FULL REFRESH instead of INCREMENTAL as the time required to update the existing system will be much higher than the time required to reload the complete data (Insert operation is almost 10 times faster than the update operation).
----
|