I have to validate 2 columns while loading my data.
I tried using this logic.
Need to load RECORD_TYPE in (1, 3).
Send me the syntax for the same.
I tried something like this...
LOAD DATA
APPEND
INTO TABLE IPDR_3G_REL2_TMP
WHEN VENDOR != 'TRA' AND VENDOR != 'HEA'
AND (RECORD_TYPE = '1' OR RECORD_TYPE = '3')
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
I am getting syntax error.
Please revert.
Cheers...