Issue: Rank column of target table is loaded with 'Yes' value instead of numbers and character values in excel? Why?
Please find attached excel sheet from which i am loading data using TOAD SQLLOADER Wizard
CTE BR Upload consolidated.xlsx (79.46 KB)Data_control.ctl.txt (216 Bytes)Data_control.ctl is the control file.
Now Rank column of excel is having both numbers and characters stored as text,using sqlloader i am loading it into target table crr_stg
Table script:
CREATE TABLE ERDCRM.CRR_STG
(
ES100 VARCHAR2(100 BYTE),
REGION VARCHAR2(100 BYTE),
REVIEW_PERIOD VARCHAR2(100 BYTE),
REVIEW_TYPE VARCHAR2(100 BYTE),
RANK NVARCHAR2(20)
)
Kindly help.