topic Re: Data load using Dynamic schema (Dynamic data type in Enterprise version) in Talend Studio

Data load using Dynamic schema (Dynamic data type in Enterprise version)

abhi90 — Mon, 09 Oct 2017 10:15:37 GMT

I want create a generic talend job with will load data from redshift to oracle table I have around 10-15 table for now .
For example:
Table1(Redshift) -> Generic_Talend_Job -> Oracle Table 1
Table2(Redshift) -> Generic_Talend_Job -> Oracle Table 2
the metadata for each source and target are different.i.e oracle and redshift table structures are same . But table 1 structure and table 2 structure are different .
I have seen option of dynamic data type in some blogs , but not sure how to incorporate the same for my case .
Sample job screenshot and configuration will be really helpful .

Re: Data load using Dynamic schema (Dynamic data type in Enterprise version)

jilanisyed — Mon, 09 Oct 2017 10:35:25 GMT

Hi Abhi,

I did the same scenario for Mysql please refer the below link for more details.

http://jilanisyed786.blogspot.in/2017/10/dynamic-schema-load-in-talend.html

Thanks

Jilani syed

Re: Data load using Dynamic schema (Dynamic data type in Enterprise version)

ravi999 — Thu, 04 Oct 2018 18:14:18 GMT

Did u face any error like while loading data from any db to redshift using dynamic schema ?

tRedshiftOutput_1 [Amazon](500310) Invalid operation: DECIMAL precision 0 must be between 1 and 38;
java.sql.SQLException: [Amazon](500310) Invalid operation: DECIMAL precision 0 must be between 1 and 38;
at com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException(ErrorResponse.java:1830)
at

Re: Data load using Dynamic schema (Dynamic data type in Enterprise version)

Anonymous — Tue, 16 Oct 2018 09:09:34 GMT

Hello @ravi999,

We have replied to your another topic:https://community.talend.com/t5/Design-and-Development/error-with-tredshiftoutput-using-dynamic-schema/m-p/136429/highlight/false#M84912.

Could you please have a look at it?

Best regards

Sabrina