I have an requirement , I need to load the below data in the my table
Below is the control file which I have created
INTO TABLE EMPDATA_TMP
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY "'"
Iam getting error for date format not being recognised and the pipe in the end. Is there an work around for it.