DSXchange

Hi,

I have simple job,

Seq stage --> Trasformer --> Teradata.

I am reading just one record from Seq file, I have manually edited the record, everything is perfect about the record..

Record :-


"C",74236526445,"HORIZON",64.00,"EA","OZ","64 OZ",789788,"210",763000161,"123456",10.2,8.5,12.8,27.00,0.642, 16,5,700600,6,789788," ","N",90,"0",0,"HORIZON","Y","S",0,0600

While loading this record in Teradata table it is getting rejected with below warning :

Untitled1..Transformer_4: The source parcel length does not match data that was defined.


I am not doing any trasformation here...hence it is surprising for me why this issue is happening.


Could you please please help me with your valuable guidance regarding this issue?

Thanks
Sagar

A Google search for your message "The source parcel length does not match data that was defined" returned about 5M hits, so there should be some help for you out there. Your record may be perfect but it doesn't match your metadata, it would seem.

Sagar,

If you post your metadata, that should be easier to help out.

No reply

Perhaps it's urgent.