User copy table

The user copy table is a target table that contains a copy of the columns in the source table. This target table can be a row or column subset of the source table, but it cannot contain any additional columns.

schema.user_copy

Server: target server

Important: If you use SQL to update this table, you run the risk of losing your updates if a full refresh is performed by the Apply program.

Except for subsetting and data enhancement, a user copy table reflects a valid state of the source table, but not necessarily the most current state. References to user copy tables (or any other type of target table) reduce the risk of contention problems that results from a high volume of direct access to the source tables. Accessing local user copy tables is much faster than using the network to access remote source tables for each query.

Table 1 provides a brief description of the columns in the user copy table.

Table 1. Columns in the user copy table
Column name	Description
user key columns	The columns that make up the target key.
user nonkey columns	The nonkey data columns from the source table or view. The column names in this target table do not need to match the column names in the source table, but the data types must match.
user computed columns	User-defined columns that are derived from SQL expressions. You can use computed columns with SQL functions to convert source data types to different target data types.