0 - 3 of 3 tags for NoPI table

It is often recommended to first load the data to a Staging table with NoPI and then use Insert/Select to load the data from the Staging table to the base/production tables vs loading the data directly to the base/production table(s).

This session provides information on the basic concepts of No Primary Index (NoPI) tables.

SI in normal table creates subtables which holds SI value, SI Row ID and PI Row ID. When we create SI on NoPI or colunar table what will be stored in SI sub table?