load data
infile '/tmp/tpc/inventory.dat'
into table inventory
fields terminated by '|'
( INV_DATE_SK, INV_ITEM_SK, INV_WAREHOUSE_SK, INV_QUANTITY_ON_HAND )
load data
infile '/tmp/tpc/item.dat'
into table item
fields terminated by '|'
( I_ITEM_SK, I_ITEM_ID, I_REC_START_DATE date "YYYY-MM-DD", I_REC_END_DATE date "YYYY-MM-DD", I_ITEM_DESC, I_CURRENT_PRICE, I_WHOLESALE_COST, I_BRAND_ID, I_BRAND, I_CLASS_ID, I_CLASS, I_CATEGORY_ID, I_CATEGORY, I_MANUFACT_ID, I_MANUFACT, I_SIZE, I_FORMULATION, I_COLOR, I_UNITS, I_CONTAINER, I_MANAGER_ID, I_PRODUCT_NAME )