Checking source data in Data Lake

After the source system data is loaded into Data Lake, use Compass to review data objects in Data Lake. You can browse the content of the data catalog or you can prepare SQL SELECT queries for data load. You can use these options to prepare load queries:

• Generate a SQL SELECT query in Compass.
• Create queries manually in relational modeling.

You can export table schemas and data from Data Lake into relational modeling. Follow these steps:

1. Generate a SQL SELECT query in Compass.
2. Copy and paste the generated query into the Query Editor in relational modeling.

   The generated query references all columns of a relational table.

3. Load data from Data Lake to Infor d/EPM.

For details on how to generate a SQL SELECT query in Compass, see the "Generating SELECT" topic in Infor ION Desk User Guide-Cloud Edition on Infor Support Portal.