Administrators may from time to time use the 'Custom Time Load' option under Tools -> Data Load Options in the Strategy Enterprise Manager 9.x console, as shown below:
Once the custom time window has begun, then administrators can watch the process progressing, as shown below:
It is possible that the user could cancel the migration. If so, there are certain scenarios that users need to keep in mind in terms of what will happen to their Strategy Enterprise Manager Warehouse because the migration was incomplete, as described below:
Metadata Migration:
If the process is canceled during Metadata Migration (meaning the Look Up tables, also called the 'Lookup Migration'), that SQL statement will continue transferring objects of the current type, but will stop before moving to the next type, or table in other words.
Fact Migration:
If the process is canceled during Fact Migration, the currently executing SQL statement will run to completion. When it finishes, the current transaction is rolled back (but not the previous transactions in this data load).
In both scenarios, the last updated table retains the incomplete data load state, so the next data load will rerun that time window before continuing with the current data.
In theory there could be some data discrepancies if the data load is canceled during the last transaction. Those can be cleaned up by using the 'WH data deletion' option in Tools -> Data Load options.
KB14083
