topic Re: toraclebulkexec using an exiting control file in Talend Studio

toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 12:09:35 GMT

Hi talend pro
I want to insert data into a oracle table using the two component toracleoutputBulk and toraclebulkexec
i create a control file .ctl
OPTIONS (DIRECT=TRUE)
LOAD DATA
CHARACTERSET 'WE8ISO8859P15'
INFILE 'C:/DNS_ODS.csv' "str ''"
BADFILE 'C:/DNS_ODS.csv.bad'
DISCARDFILE 'C:/DNS_ODS.csv.dsc'
INTO TABLE KPI.DNS_ODS
APPEND
FIELDS TERMINATED BY ";"
TRAILING NULLCOLS
(
"column1",
"date" " TO_DATE(:date_dns,'DD-MM-YYYY HH24:MI S')",
..)
but after run an error that :
SQL*Loader-466: La colonne "column1" n'existe pas dans la table KPI.DNS_ODS.
Exception in component tOracleBulkExec_1
can you help me how i reseolve it , and thanks for your great help

Re: toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 15:37:36 GMT

Hi Fetyna,
What is the target metadata of the table? Whether it is matching with your input metadata?
Vaibhav

Re: toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 15:41:47 GMT

Thanks Vaibhav for your reply,
In fact I have erro in ctl file, and now no problem i resolve it
but jobs run properly and data not inserted in the table
have you any idea what can be the problem and how can i reseolve it
Thanks
Fetyna

Re: toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 15:43:57 GMT

Hi Fetyna,
Connect reject to file, you will get idea.. When data is not inserted and there is no error, it means that the records are rejected due to some metadata issues...
Disable Die on error and Batch checkbox, you will get reject link from database output component.
vaibhav

Re: toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 15:58:45 GMT

Thanks vaibhav for your explanation
you 're right
in fact i use tmap for change the order of rows
and add the date,
so you can undertand me wehn you show the snop show
in the file name of the component toracleoutputbulk the file conserve the same structure of the initial file and not after the map
and when i see the log file : data rejected because number does'nt valid
so what should I do ?
thanks for your help

Re: toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 16:24:51 GMT

Oh... that's good that you have identified the issue.
Create ST mapping document and verify talend job metadata vs target data
This will help.
Thanks
Vaibhav

Re: toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 16:33:16 GMT

Thanks Vaibhav,
How can I create ST mapping document ?
and you can explain to me :
toracleoutputbulk why should i define the file name in its basic settings
and should I indicate this file in the ctl file ??
because now toraclebulkexec can't find the infile that i indicated in the ctl file

Thanks
Fetyna

Re: toraclebulkexec using an exiting control file

Anonymous — Wed, 09 Jul 2014 17:21:41 GMT

ST mapping document is simple excel document which relates input columns to output columns...
Vaibhav

Re: toraclebulkexec using an exiting control file

Anonymous — Sat, 12 Jul 2014 18:39:43 GMT

Thanks Vaibhav for your reply
in fact i use just toracle bulk exec and i indicat the file.ctl
but when i run , i have this error SQL*Loader-466 column does'nt exist in the target table
but column exist and sql loader does'nt find it
can you help me how i reseolve it
Thanks