Work with staging databases by specifying staging at the database and target levels, staging and target at the job and system levels, and a secondary staging database.
Staging tables are created as NOPI tables unless TPTAPI_UPDATE is being used to load data to the staging table. TPTAPI_UPDATE does not support loading to a NOPI staging table. In this case, the staging table is created with the same Primary Index as the source table.