Setting the parameters for running the data warehouse load procedure - HxGN EAM - 12.0.1 - Installation & Upgrade

HxGN EAM Application Installation

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
12.0.1

Set the parameters for running the data warehouse load procedure to indicate whether to initiate a full or partial data load, and to specify the date from which to load data. The system always runs a full load first and then sets the data load to the incremental setting. Save the settings for future use as necessary.

Note: Executing a data warehouse data load is an intensive database process, and Infor strongly recommends that you only initiate a data load during non-peak system usage hours.

The AETL process periodically updates HxGN EAM Analytics data. If you are installing HxGN EAM Analytics for the first time, you should complete a full load of the data warehouse ETL. If you are upgrading HxGN EAM Analytics from a previous version, you should only perform incremental loads of the data warehouse ETL. Performing a full load after an upgrade will result in the loss of data.

  1. Select Administration > Data Collection > Data Warehouse Run Parameters.

  2. Select the Execute Load Procedure check box to enable the data warehouse ETL job to execute the data load process to transfer production data into the data warehouse tables.

  3. Specify this information:

    Load Type - Select one of the following options:

    Option

    Description

    Full

    Select to execute a full data load.

    Incremental

    Select to execute an incremental data load.

  4. Specify the Load from Date.

    You should only select Full as the Load Type when running the ETL process for the first time or after removing errors. After running a clean full load, you do not need to run a full load again unless you want to delete the existing data from the data warehouse.

    The Load from Date should generally be set from the beginning of the calendar or fiscal year two or more years in the past. When selecting the date, consider that each year added to the data warehouse results in the use of additional database space. Only include years for which the data is useful for analysis.

    You can select Purge Old Data and set Purge to Date to the date through which records should be purged. The next time the ETL runs, it will first purge records with dates on or before Purge to Date. The ETL will then clear the Purge Old Data check box, and continue with the load process. Hexagon strongly recommends that you select Purge Old Data if you are going to run a full data load.

    After running a full load with no errors, all future loads should be incremental. After completing a full load, the system automatically resets the Load from Date to the current date (date of the most recent load) and sets the Load Type to Incremental.

  5. Click Save Record.

    Saving the run parameter settings applies the run parameter settings to the regularly scheduled ETL process and will be in effect when the system executes the process as scheduled.

    You can set the run parameters to execute both a data load and data purge process simultaneously. To execute a data load and data purge simultaneously, select both Execute Load Procedure and Purge Old Data, and then enter a Load Type, Load from Date, and a Purge to Date.

    The default setting indicating the threshold for committing records to the data warehouse tables is 1500 records. If you would like to specify a different threshold, a database administrator must reset this value in the database. Contact your database administrator for additional information.

    Each step of the load process is recorded in the data warehouse run log. See Viewing the data warehouse run log.