Schedule Frequent Refreshes of Warehouse Tables

You can select warehouse data tables for frequent data refresh ahead of other data in the regularly scheduled batch. For a table to be eligible for a frequent data refresh, ensure that its supporting functional areas are activated.

After you select the warehouse tables for frequent data refresh and save your selection, the selected tables are available as "Warehouse Tables" under the Frequent Refresh tab. You can set the frequent refresh schedule for these tablesin the Frequent Refresh tab. See Schedule Frequent Refreshes of Data.

Ensure that Frequent Refresh Tables is enabled in Pipeline Features under the Preview Features tab on the Enable Features page prior to scheduling frequent refreshes of the tables. See Make Preview Features Available.

  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse Console, click Data Configuration under Application Administration.
  3. On the Data Configuration page, under Configurations, click Pipeline Settings.
  4. On the Pipeline Settings page, click Frequent Refresh Tables.

    Frequent Refresh Tables tab

  5. In the Frequent Refresh Tables tab, select the check boxes for the applicable warehouse tables and click Save.