Prepare Load Scripts

Note: You can postpone this step if your goal is to test a logical schema design for validity.

Prepare SQL scripts to load data directly into physical storage using the COPY...DIRECT statement using vsql, or through ODBC as described in Connecting to Vertica.

You need scripts that load the:

OpenText recommends that you load large tables using multiple files. To test the load process, use files of 10GB to 50GB in size. This size provides several advantages:

See Bulk-Loading Data and the following additional topics for details:

Tip: You can use the load scripts included in the example databases in Getting Started as templates.