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.

Caution:

Load queries are canceled after 2 hours. Do not develop load queries, mappings, or scripts that take longer than 2 hours to run. You can specify a time-out for queries, up to a maximum of 2 hours, in the properties of the Modeling Service.

A banner is displayed while scripts and load queries are running. In the banner, you can cancel scripts that you are running, or which another user is running.