Appendix: Onboarding existing clients to Data Lake - HxGN EAM - Version 11.07.01 - Feature Briefs

HxGN EAM Data Extracts with Infor Data Lake

Language
English
Product
HxGN EAM
Search by Category
Feature Briefs
HxGN EAM Version
11.7.1

Prior to the EAM 11.6.1 release, it was not possible to send records to Data Lake if they did not have a value populated for the xxx_lastsaved column. These records were manually updated by Infor® support services. Going forward, EAM will automatically create a new "partner" table when a table is being added to a Data Lake Schedule and there are records in that table without a value for the xxx_lastsaved column. This new "partner" table will hold all PK columns of the table entered, plus one extra column to hold the xxx_lastsaved value (which will get populated with a distinct value for each record). EAM will then also create a view, which will join the original table with the newly created "partner" table (using the PK). As a final step, EAM will then automatically add this view to the set of tables of the current Data Lake Schedule.

This process will be supported by the job, DLVWCR, which will check daily at 2:00AM if a new table/view should be created.

There will also be two associated install parameters:

Install parameter

Description

DLAUTOVW

Set to 'YES' if a view should be created automatically when adding a table to a Data Lake Schedule ID which has records with no value for the xxx_lastsaved column.

DLRECLIM

When adding a table to a Data Lake Schedule which has more records without a value for the xxx_lastsaved column than the specified number, a nightly job will be used to create the special view to process these records. Otherwise, this will happen upon saving the table addition.

The default for DLRECLIM will be 1000000. This install parameter will not be displayed, so the user cannot change it. This means for tables with less than a million records, the job will not be used, the view will be created when saving the record.