SQL Loader Script to load data in specific columns of the staging table

Hi All,

We have one requirement where we need to load data in staging table from CSV file. There are around 200 columns in the staging table but we need to enter value in 10 columns only and rest of the columns needs to be blank.

Could you please provide the CTL file script to insert data in specific columns of the table.

I have tried using below one but it went into error.

Here we need to update below 17 columns of the table only.

But i think below script format is not correct.

OPTIONS (SKIP=1)

LOAD DATA

INFILE *

APPEND INTO TABLE XXEEG.CSI_INSTANCE_INTERFACE(INST_INTERFACE_ID,