Clarity

 View Only
Expand all | Collapse all

Load Data Warehouse (full or incremental) - Schedule

Jump to Best Answer
  • 1.  Load Data Warehouse (full or incremental) - Schedule

    Posted Jun 16, 2015 07:15 AM

    Just wanted to check as to how is the Load Data Warehouse (full or incremental) is schedule ?

     

    We are looking at full - once a month.

     

    At what frequency have you scheduled the incremental load ? - Once or twice a day (off-peak hours) ?

     

    Apologies if I have missed on looking at any other documentation.

     

    Regards

    NJ



  • 2.  Re: Load Data Warehouse (full or incremental) - Schedule
    Best Answer

    Broadcom Employee
    Posted Jun 16, 2015 08:40 AM

    Hey NJ,

     

    The frequency of the job determines the freshness of the data within the Data Warehouse. We recommend that you execute the job once every day during non-peak hours.

     

    Run the job with the Full Load option selected in the following cases:

    ■ You add a new language in the Data Warehouse system options. Running an incremental load of the job does not update the Data Warehouse with the new language.

    ■ You delete an attribute or unselect the "Include in the Data Warehouse" option for the attribute in Studio. You cannot re-enable the attribute for inclusion in the Data Warehouse unless at least the job has completed one run.

    ■ You change the entity for fiscal periods in the Data Warehouse options.

    ■ You change the timeslice dates to include a larger timeframe.

     

    Additionally, run the job each time the data type of an attribute that is included in the Data Warehouse is changed in Studio. First disable the attribute, then run the job. Next, reenable the attribute with the correct data type, and rerun the job for the changes to take effect.

     

    Full Load

    Rebuilds the Data Warehouse from scratch if selected. If the option is not selected, the job only looks for incremental changes since the last time you ran it. If you are running the job for the first time to populate the Data Warehouse, select this check box.

    We recommend that you run the job with the Full Load option selected during off peak hours for better performance. At other times, run the job for incremental loads.

     

    Regards

    Suman Pramanik



  • 3.  Re: Load Data Warehouse (full or incremental) - Schedule

    Posted Jun 16, 2015 09:57 AM

    Thanks for your response, Suman

     

    Regards

    NJ