Loading data

Relational modeling uses load queries to load data into tables. This applies in standard integration tables and in custom staging tables. You use a load query to transfer data from a source system directly to an integration table, or to staging tables. You can write queries to transfer data from one staging table to another.

In a load query, you specify a SELECT or SELECT AS query to load data from a source table. If the columns match, the result set of the query is loaded into the table.

Note: Data loads are fastest if the target table has no primary key, thus removing the requirement to check that each record is unique.

If the source table has columns that are not in the target table, you can add those columns while running the load query.