DATE insertion from Dynamic schema into ORACLE

Mahesh6 — Sat, 16 Nov 2024 04:39:52 GMT

Hi all,

Good day ,

I am kind of new to the Talend community version , I have a task which includes fetch a file from FTP server create a TEMP table of it and then insert that data into TARGET table. There will be lots of file in FTP server every file has Different Schema and need to be create new temp table for every file and dump a data to TARGET(Different Schema) table.

So for different schema I have used Dynamic schema , I have completed my task until temp table creation but while dumping into TARGET table for TIMESTAMP column it gives error :

"Exception in component tDBOutput_2 (ETL_FetchFileFTP)
java.sql.SQLDataException: ORA-01861: literal does not match format string "

I have tried all date patterns while dumping data but always get above error.
If I use Dynamic schema with same structure like TARGET table but different data type (I mean created temp table with all columns with VARCHAR datatype but TARGET table has different datatype), Do I need to convert each and every field according to TARGET table datatype structure ? if Yes then How ? and if No then How will I resolve this issue.

i have referred dynamic schema articles but I couldn't resolve it.

please find an attachment.

Re: DATE insertion from Dynamic schema into ORACLE

manodwhb — Tue, 17 Sep 2019 07:53:07 GMT

@maheshvardam ,Dynamic schema will not convert the date for source to required date format to load into target,since you need to define the date format conversions manually.

Re: DATE insertion from Dynamic schema into ORACLE

Mahesh6 — Tue, 17 Sep 2019 07:59:51 GMT

@manodwhb, How Do I suppose to do that ?

topic Re: DATE insertion from Dynamic schema into ORACLE in Talend Studio

DATE insertion from Dynamic schema into ORACLE

Re: DATE insertion from Dynamic schema into ORACLE

Re: DATE insertion from Dynamic schema into ORACLE