topic Re: Empty DB type in output table schema for fields calculated by variable in a tMap in Talend Studio

Empty DB type in output table schema for fields calculated by variable in a tMap

mauerwegrunner — Mon, 27 Mar 2023 10:09:36 GMT

Hello,

I am calculating simple integer numbers (not null) in a tMap's variable section. When these fields are going to be loaded in an output table with option drop table if exists and create for these fields there is no db datatype preselected. Also for another field which is a string and which is filled by a context variable. And this variable is being used in every job and there was never a problem with this database's datatype.

Is this is a normal behaviour? I've been using Talend since 5 years and I've changed to Enterprise on premise this year. Target DB is postgres database.

What might be the reason? The xml file which maps the internal DB types to the target`s DB type shows an int4 for this.

thanks and regards

Matthias

Re: Empty DB type in output table schema for fields calculated by variable in a tMap

Anonymous — Tue, 28 Mar 2023 01:54:29 GMT

Hello Matthias,

Could you please try if you can select the DB Type for the above 4 fields in the output schema of PSQL_DWH_OP manually?

Thanks

Re: Empty DB type in output table schema for fields calculated by variable in a tMap

mauerwegrunner — Tue, 28 Mar 2023 07:04:09 GMT

Hello achen,

thanks for your answer. Selecting manually works. However it would be better to get his mapped automatically like it does in the first three columns of this schema.

I've tested some solutions. sync columns does not work, but, when I save and close and reopen it, then the warning symbol about different schemas appears:

And then sync columns works and all columns are correctly assigned to a database datatype without manual work. This workaround works.

I suppose the reason is using a variable in a tMap in this subjob.

Thanks and rregards, Matthias