dynamic schema import wrong data type

Anonymous — Tue, 19 Mar 2019 06:20:49 GMT

Hi every one,

i have a simple Job like this:

tinputdelimitedFiles ==> tmssqloutput.

the columns in the tinputdelimitedFiles are: ID(int),Name(varchar),others(dynamic, which contain 2 columns: Sale(int) and Discount(int))

i import the csv. File in to a Sale Table in MSSQL and when i open the Sale Table. the columns Sale and Discount have Data type as varchar.

i have try to change the Setting of Database Datatype of the dynamic Column "others" in the tmssqloutput to integer, and run the job again, but it still show me the same Data type for Sale and Discount.

Can you please help me how to import correct Data type of the column Sale(int) and Discount(int) when we use dynamic schema?

Thankyou

Re: dynamic schema import wrong data type

akumar2301 — Thu, 21 Mar 2019 12:32:07 GMT

did you try tSetDynamicSchema and try to send column data type as id_Ineger.

https://help.talend.com/reader/KxVIhxtXBBFymmkkWJ~O4Q/_N82Hv0ivAnxD69EWaC5rA?section=jzhang-20120422-file-tfileinputpositioonal_dynamic

topic Re: dynamic schema import wrong data type in Talend Studio

dynamic schema import wrong data type

Re: dynamic schema import wrong data type