Incremental Load

The Incremental Load (fact load type 3) restricts the load to version numbers specified in the _FactLoad table. The last loaded version and newest version to load are read by the process and are matched to the version numbers of the rows in the fact table. They are selected if their version numbers fall in range.

Unlike the Full Load and Partial Load, the Incremental Load does not clear a cube region before loading. It adds values to existing values in the cubes rather than replacing them.

An incremental load cannot have job parameters restricting element combinations loaded into the cube as the Partial Load has. Incremental loads are restricted only by version numbers.