Reload Options

Most solutions have the need to merge new/updated data into existing fact tables and then process the changes efficiently in the data warehouse.

At the data source level the user has the choice of several options when setting up a fact source table for efficient reload.

PS6_Reload_Part1_SalesEx.PNG

 

To ensure only new (or changed) data is loaded into the data warehouse you can utilize the Incremental Reload option.

This reload option is especially effective if it is combined with the "Maintain RELOADVALUE tag" option.

Now the user can utilize partitioning. 

 

PS6_Reload_Part2_SalesEx.PNG

Change statisctics are now tracked for each individual partition boundary:

PS6_Reload_Part4_SalesEx.PNG 

 

This allows you to process only changed partitions via the "Process by changes in (specific) Fact Sources" command.

PS6_Reload_Part3_SalesEx.PNG