load data
infile '/tmp/tpc/call_center.dat'
into table call_center
fields terminated by '|'
( CC_CALL_CENTER_SK, CC_CALL_CENTER_ID, CC_REC_START_DATE date "YYYY-MM-DD", CC_
REC_END_DATE date "YYYY-MM-DD", CC_CLOSED_DATE_SK, CC_OPEN_DATE_SK, CC_NAME, CC_
CLASS, CC_EMPLOYEES, CC_SQ_FT, CC_HOURS, CC_MANAGER, CC_MKT_ID, CC_MKT_CLASS, CC
_MKT_DESC, CC_MARKET_MANAGER, CC_DIVISION, CC_DIVISION_NAME, CC_COMPANY, CC_COMP
ANY_NAME, CC_STREET_NUMBER, CC_STREET_NAME, CC_STREET_TYPE, CC_SUITE_NUMBER, CC_
CITY, CC_COUNTY, CC_STATE, CC_ZIP, CC_COUNTRY, CC_GMT_OFFSET, CC_TAX_PERCENTAGE 
)