Example Table Details

The following example displays the data inserted and updated into the FDI_REFRESH_SUMMARY, FDI_REFRESH_STAGES, and FDI_REFRESH_FACTORS tables during incremental refresh for the source FUSION running 3 stages (Priority, Primary, and Secondary). Assume the unique for the tenant refresh instance id is 2508290162. All the times shown are in UTC.

Here's the information in each of the tables at the end of the successful completion of the refresh.

FDI_REFRESH_SUMMARY

SOURCE_TYPE_CODE	REFRESH_TYPE	REFRESH_ID	NUM_STAGES	STATUS	SCHEDULED_TIME	COMPLETION_TIME	PUBLISHED_REC_COUNT
FUSION	DataRefresh	2508290162	4	Completed	29-Aug-25 12.05.00.000 AM	29-Aug-25 09.35.00.000 AM	1234102011

FDI_REFRESH_STAGES

REFRESH_ID	STAGE_NAME	COMPLETION_TIME
2508290162	PRIO_DATA_PUB_ORD_0	29-Aug-25 04.15.00.000 AM
2508290162	PRIO_DATA_PUB_ORD_1	29-Aug-25 06.55.00.000 AM
2508290162	DATA_PUBLISHED	29-Aug-25 08.58.00.000 AM
2508290162	POST_PROCESSING	29-Aug-25 09.35.00.000 AM

FDI_REFRESH_FACTORS

REFRESH_ID	FACTOR_CODE	FACTOR_DETAILS
2508290162	SOURCE_MAINTENANCE	232
2508290162	CUSTOMER_HIGH_ADW_SERVICE	1