Post Load SQL

The script entered in the Post Load SQL box is used to perform certain calculations after extraction is completed and data has been loaded into the Insight tables.

Queries in this section will reference the destination tables and columns and will be applied to all extracted data available in the Infor Risk & Compliance system. Post load SQL can be written for the entire volume of  data in that table starting from the very first extraction. This is the primary difference between using derived tables and Post Load SQL.

• If the SQL operation is to be only applied on the current extracted data set, use derived tables.
• If the SQL operation is to be applied on entire data set (current and previous extracts), use Post Load SQL.