load data
infile '/tmp/tpc/web_page.dat'
into table web_page
fields terminated by '|'
( WP_WEB_PAGE_SK, WP_WEB_PAGE_ID, WP_REC_START_DATE date "YYYY-MM-DD", WP_REC_END_DATE date "YYYY-MM-DD", WP_CREATION_DATE_SK, WP_ACCESS_DATE_SK, WP_AUTOGEN_FLAG, WP_CUSTOMER_SK, WP_URL, WP_TYPE, WP_CHAR_COUNT, WP_LINK_COUNT, WP_IMAGE_COUNT, WP_MAX_AD_COUNT )