OPTIONS(DIRECT=TRUE,ERRORS=100000)
LOAD DATA INFILE './data/SAMCHLD1.dat'
APPEND
INTO TABLE SQD_SAMCHLD1_NATIVE_LANG_TEXT
FIELDS TERMINATED BY '~' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(
ETL_SOURCE_APPLY_DTTM
,ETL_SOURCE_CAPTURE_DTTM
,ETL_SOURCE_CDC_ACTION_CODE
,ETL_SOURCE_KEY
,ETL_SOURCE_SYSTEM_INSTANCE
,ETL_SOURCE_SYSTEM_ORIGIN
-- Parent Keys
,RT_BRANCH
,RT_ACCT_OFFICER
-- Segment Key
,C1_TEXT_LINE_NO
-- Segment Data
,C1_RCRD_TYPE
,C1_TEXT_LINE_TYPE
,C1_NON_ROMAN_TEXT CHAR(140) "UTL_RAW.CAST_TO_NVARCHAR2(HEXTORAW(:C1_NON_ROMAN_TEXT))"
)