Query result sets that match the integration table schema

To retrieve the same table schema as the integration table schema, you can use these methods:

  • Within a load query in relational modeling, transform data from Data Lake.
  • Load data from Data Lake into the Staging database, transform the data with load queries or scripts, and then load the data into the corresponding integration table.

In the Staging database, you can perform these data transformations, for example:

  • Change an alphanumeric ID to a numeric ID in, for example, the Accounts table.
  • Change a not allowed account type to a type that is allowed in Infor EPM.
  • Change a currency name to a currency ISO code.