Previous Topic: Truncate_On_Next_RunNext Topic: Fact_Expiry_Age_Months


Resync_On_Next_Run

Use this parameter to resync all the data in data warehouse. A resync operation ensures that events and participant details in the Event Participant Fact table exactly correspond to the event tables in the CMS database.

Syntax

Set this parameter to 1 to synchronize all event and participant data in the data warehouse with the event tables in the CMS.

Set this parameter to 0 to cancel the resync operation.

SQL Server
@Resync_On_Next_Run=1 or 0
Oracle
Resync_On_Next_Run=>1 or 0 
Note

This parameter resets to 0 after the resync has completed.

More information:

Resync the Event Participant Fact Table