- You cannot load rows into a column-partitioned table using the MultiLoad or FastLoad utilities.
- You can load rows into a column-partitioned table using Teradata Parallel Data Pump array INSERT operations.
You can also use INSERT … SELECT statements to load rows from a source table into a column-partitioned target table. The source can be a primary-indexed table, a column-partitioned table, or an nonpartitioned NoPI table.
For more information about using the Teradata Parallel Data Pump utility to load rows into a column-partitioned table, see Teradata® Parallel Data Pump Reference, B035-3021 and Teradata Vantage™ - Database Design, B035-1094.