This is how my control file look like.

load data
infile "-"
append
into table test
fields terminated by ' '
TRAILING NULLCOLS
(empid ,
empname ,
empdate)