Please, I'm currently facing an error when using Informatica Powercenter to read Source table from Teradata (V13.10) and inserting records in a target Teradata DB.
However, when a Teradata source (table) definition has a field where the length is shorter than the target correspondent field, we got the following error:
Conflicting data length for column(10) - IRZ_SCIAL. Source column's data length is (70) Target column's data length is (100).
There is no truncation happening. But, Teradata seems that does not allow an insert where columns length are different.
We can overcome this error by manually fixing the involved source column length. Howerver, there are tons of tables to be updated and I' trying to understand why such restriction is applyied by Teradata and if there is a way to bypass this error.
Thanks in advance,
this is not a Teradata restriction, source and target length does not have to match, it must be PowerCenter related.
In a Teradata mode session Teradata happily inserts 20 characters in a VarChar(10) and silently truncates after the 10th character :-)
Only ANSI mode session complain with a "right truncation of string" error message.
So, there is nothing implicet by Teradata that would force such behavior, right?
Because the error showed "TPTRD_306 : [ERROR] Type:(Teradata PT API Error), Error: (TPTAPI_INFRA: API306: Error: Conflicting data length for column(10) - IRZ_SCIAL. Source column's data length is (70) Target column's data length is (100).)" seems to be in the border line.
it's not Teradata, but you should have mentioned that it's a TPT error :-)
TPT is picky about correct length definition, at least when you define an input file.
I don't know about the TPT API stuff, but Steven Feinholz as the TPT guru might provide further assistance.
This is an old thread but of interest to me.
I am getting the same error while using TPT LOAD connection from Informatica but the issue is that my source and target tables are absolutely identical.
Message Code: TPTRD_306
Message: [ERROR] Type:(Teradata PT API Error), Error: (TPTAPI_INFRA: API306: Error: Conflicting data length for column(4) - billing_type. Source column's data length is (3) Target column's data length is (2).)