Issues with Teradata Parallel Transporter(TPT) with Informatica

Database

Issues with Teradata Parallel Transporter(TPT) with Informatica

Hi,

 

We are using Teradata Parallel transporter (TPT) loaders as both source and target connection.

 

     Source     - TPT Export

     Target      - TPT Load

 

Using that performance has improved significantly compared to relational connection.

 

1) But we are facing issue like Data Corruption.

 

Lets consider source table has some character column. Consider below example

 

Column1 - char(4)

----------------------------

ABCD

AB

AJ

 

Target table has same defination as of Source table. But after processing data using TPT the data gets appended with some extra characters.

 

Column1 - char(4)

----------------------------

ABCD

ABX

AJU

 

And this result is random not all mappings/columns gets same issue. Also not all data value gets this issue. Only few records.

 

We are unable to come to any undestanding regarding this. Please help.

 

2) Also explicit casting is required for all case statement and for decimal columns having precision high as decimal (18,0). Why is that so?

 

-Amresh Jha

2 REPLIES
Teradata Employee

Re: Issues with Teradata Parallel Transporter(TPT) with Informatica

It can be due to UTF encoding issue .... can you check if source-TPT-target is configured to use same encoding?

Enthusiast

Re: Issues with Teradata Parallel Transporter(TPT) with Informatica

jhaamresh,

For 1) I have faced this issue, to resolve, use Ltrim(rtrim(port)), right before loading it into the target. I tried several other options, but this one fixed/resolved my problem.

For 2) can you please clarify if you are using the decimal(18,0) inside the Soruce qualifier?

Thanks,

Prabhakar. T