tMap with dynamic schema

[Anonymous]

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]

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]

Target - Oracle
Design Screenshot:

          

tMap Editor:

  

DBOutput: