Prepare Actual Data Files

Prepare the actual data files for your initial bulk load. Vertica Systems, Inc. recommends that you load your fact table data using multiple files of roughly 10GB to 50GB each. This size provides several advantages:

• You can use one of the fact table data files as a sample data file.
• You can load just enough fact table data to Test a Partially Loaded Fact Table before loading the remainder.
• If a single fact table load fails and rolls back, you do not lose an excessive amount of time.

See Bulk Loading for more information.

How to Name Data Files

Name each data file to match the corresponding table in the logical schema. Case does not matter. Use the extension .tbl or whatever you prefer. For example, if a table is named Stock_Dimension, name the corresponding data file stock_dimension.tbl. When using multiple data files, append _nnn (where nnn is a positive integer in the range 001 to 999) to the filename. For example, stock_dimension.tbl_001, stock_dimension.tbl_002, etc.