Enhanced As-of Date Handling for FTP Lookup Table Data Loads

While loading data into an FTP lookup table, the handling of As-of Date values depends on whether the “Use As-of Date” flag is enabled during lookup table configuration.

• When the Use As-of Date flag is enabled, the input data file must contain records for only one As-of Date, corresponding to the MIS Date for which the batch is executed. If multiple As-of Dates are present in the file, the system loads data only for the MIS Date and ignores records associated with other As-of Dates.
• When the Use As-of Date flag is not enabled, the system allows loading multiple As-of Dates in a single file. However, if Delete and Insert is selected during execution, the entire lookup table is truncated without considering the as of date before loading new data.
• If the Use As-of Date flag is enabled and Delete and Insert is selected, the system deletes data only for the As-of Date corresponding to the MIS Date for which the batch is executed, instead of truncating the entire table.

Business Benefit:

This enhancement ensures predictable and controlled data loading behavior for FTP lookup tables, reduces the risk of unintended data loss, and provides greater flexibility in managing As-of Date–based data across batch executions.

Steps to Enable and Configure

You don't need to do anything to enable this feature.