Problem in control script for sqlldr

CloverDX Platform
1

I am giving a csv file as file url to loader. But, after loading, I find only one column is loaded and for others values are not inserted. The log of clover shows successful.

In path to control script, we get control script dialog. there I am writing script like

LOAD DATA
INFILE *
INTO TABLE DEP
APPEND
(
DEPNO, STAFF, SALARY
)

For one other loaded, no insertion could happen in table.

Let me know where I may be going wrong.

Any link with details about sqlldr will be helpful.

2

Hello,
you should defined type of metadata (fixed, delimited) in the control script.
Try use this control script:

LOAD DATA
INFILE *
INTO TABLE DEP
APPEND
(
DEPNO TERMINATED BY ‘,’,
STAFF TERMINATED BY ‘,’,
SALARY TERMINATED BY ‘,’
)

When this script won’t be success, send me a graph and execution log.

Tip: when you create a Clover metadata in your graph and connect them to input port of OracleDataWriter then OracleDataWriter can generate default script for the metadata (in dialog where control script is defined)

New simple example for OracleDataWriter:
http://wiki.cloveretl.org/doku.php?id=c … ata_writer

More info about sqllder:
http://download.oracle.com/docs/cd/B137 … tm#i436326

Info about sqlldr control script:
http://download.oracle.com/docs/cd/B137 … m#i1006645

3

Thanks a ton for help.