topic Re: tMap with dynamic schema in Talend Studio

tMap with dynamic schema

Anonymous — Sat, 16 Nov 2024 04:35:59 GMT

I'm trying to create a table with dynamic schema using 'Dynamic' datatype from flat file as source.

But even after using 'NVARCHAR2' as a Datatype. I'm getting the below error if the length of the column exceeds 100

ORA-12899: value too large for column "XYZ" (actual: 107, maximum: 100)

and I can also see all the fields are having a maximum length of 100 created.

What can be done to avoid this and create length of the field as per the maximum length of the data from source file?

Anonymous — Tue, 24 Sep 2019 08:45:10 GMT

Hello,

What's your target output? Could you please post your tMap editor screenshot here? In this way, we could get more information from your setting.

Best regards

Sabrina

Anonymous — Wed, 25 Sep 2019 23:45:18 GMT

Target - Oracle
Design Screenshot:

tMap Editor:

DBOutput: