load data
infile '/tmp/tpc/household_demographics.dat'
into table household_demographics
fields terminated by '|'
( HD_DEMO_SK, HD_INCOME_BAND_SK, HD_BUY_POTENTIAL, HD_DEP_COUNT, HD_VEHICLE_COUNT )