I have a mapping which uses sql loader
Oracle sql loader can do many things with column values during the import
for example here is a simple substring (substr) example in a control file
INTO TABLE mailing_list
FIELDS TERMINATED BY ","
mailing_addr "decode(:mailing_addr, null, :addr, :mailing_addr)",
mailing_city "decode(:mailing_city, null, :city, :mailing_city)",
move_date "substr(:move_date, 3, 2) || substr(:move_date, 7, 2)"
how can I do that in a mapping which uses the
LKM File to Oracle (SQLLDR)
loading knowledge module?
Unfortunately this is not possible because LKM File to Oracle (SQLLDR) creates dynamically the CTL file.