Running a load query manually

When you run a load query manually, you can add missing columns to a table in addition to loading data.

Select Dashboards > Data Integrations > Relational Modeling.
Select Staging from the Target Connection list.
Expand the Tables node and select the table to which to load data.
Click the Load Queries tab.
Select your application from the Application list.
All previously saved queries are listed.
Select a load query and click Preview.
If the query syntax is valid, a preview of the columns and first twenty rows of the query result is displayed.
Note: The preview displays only the query result. It does not reflect the schema of the target table which, depending on the load query, can differ from the source table schema.

Select one of these options:

Option	Description
Load Data	The data is loaded from the source table to the target table. Select this option if the columns of the source and target tables match, or if you do not want to load data from any additional columns in the source. If the target table has columns that are not in the source, then only those columns that are common to both tables are populated.
Load Columns and Data	Columns that are in the source table but not in the target are listed. You are prompted to load the columns or the columns and their data. Select Column or Column and Data and click Load.

Option

Description

Load Data

The data is loaded from the source table to the target table.

Select this option if the columns of the source and target tables match, or if you do not want to load data from any additional columns in the source.

If the target table has columns that are not in the source, then only those columns that are common to both tables are populated.

Load Columns and Data

Columns that are in the source table but not in the target are listed. You are prompted to load the columns or the columns and their data.

Select Column or Column and Data and click Load.